[GENERAL] CAST

[Enrico Comini]

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