Re: Numeric Problem

> -----Original Message-----
> From: jack [mailto:datactrl(at)tpg(dot)com(dot)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.