CAST
Started by Enrico Cominiover 25 years ago2 messagesgeneral
Hi, how I have to change the next query ?
da_kg=Numeric
a_kg =Numeric
cusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg < 3.5) and (a_kg >= 3.5));
ERROR: Unable to identify an operator '<' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
Re: CAST
Enrico Comini writes:
Hi, how I have to change the next query ?
da_kg=Numeric
a_kg =Numericcusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg < 3.5) and (a_kg >= 3.5));
ERROR: Unable to identify an operator '<' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
CAST(3.5 as numeric)
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/