Gee, this sounds familiar.
See the question (
http://archives.postgresql.org/pgsql-sql/2002-11/msg00191.php ) I posted of
a similar nature a couple of days ago.
We decided to wait for 7.3/7.4 and in the mean time we're using CAST (
'constant value' as numeric ).
Thanks,
Paul Ogden
Claresco Corporation
(510) 549-2290
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of jack
> Sent: Thursday, November 14, 2002 18:22
> To: pgsql-sql@postgresql.org
> Subject: [SQL] numeric problems
>
>
> I'm using pgAdmin II version 1.3.82 , psqlODBC 7.2.3 ,
> postgreSQl 7.2.1. There is a problem when I do an SQL query
> with a field of numeric, for eample NUMERIC (10.2). Following
> staement causes an error such as "Unable to indentify an
> operator '>' for type 'numeric' and 'double precision'..."
>
> select itemNo, listprice from itmt_info
> where listprice > 50.99;
>
> And this one works.
>
> select itemNo, listprice from itmt_info
> where listprice > '50.99';
>
> It seems all numeric operators are not available on NUMERIC
> FIELDS. Is there
> anyone has done somethings on this problems? Or should I change
> NUMERIC type
> to FLOAT type? Please advise, thank you in advance.
>
> Jack
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html