Re: [GENERAL] CAST

[Peter Eisentraut]

Enrico Comini writes:

> 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

CAST(3.5 as numeric)

-- 
Peter Eisentraut      [EMAIL PROTECTED]       http://yi.org/peter-e/