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: [EMAIL PROTECTED] > [mailto:pgsql-sql-owner@;postgresql.org]On Behalf Of jack > Sent: Thursday, November 14, 2002 18:22 > To: [EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
