CAST - Mailing list pgsql-general

From Enrico Comini
Subject CAST
Date
Msg-id NCBBIOBMPJJBPJICNDLLEEAIDGAA.algobit@algobit.com
Whole thread Raw
Responses Re: CAST  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Postgresql 7.0.2 under WinNT
Next
From: Peter Eisentraut
Date:
Subject: Re: CAST