CAST

From: "Enrico Comini" <algobit(at)algobit(dot)com>
To: "ML-Postrges-general" <Pgsql-General(at)Postgresql(dot)org>
Subject: CAST
Date: 2000-09-28 08:56:30
Message-ID: NCBBIOBMPJJBPJICNDLLEEAIDGAA.algobit@algobit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: CAST at 2000-09-28 09:20:26 from Peter Eisentraut

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-09-28 09:20:26 Re: CAST
Previous Message Peter Eisentraut 2000-09-28 08:45:31 Re: Postgresql 7.0.2 under WinNT