> -----Original Message----- > From: jack [mailto:datactrl@;tpg.com.au] > Sent: 14 November 2002 01:57 > To: pgadmin > Subject: [pgadmin-support] Numeric Problem > > > Dave, > > 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'; > > I think it could be psqlODBC's problem. Would you please > check this problem. Thnak you!
No, it is PostgreSQL complaining that there is no numeric > float operator available. You will need to create one, but here is not the place to ask about that - try looking in the PostgreSQL docs included with pgAdmin or using one of the PostgreSQL mailling lists. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
