Thread: Numeric Problem

Numeric Problem

From
"jack"
Date:
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!


Jack


Re: Numeric Problem

From
"Dave Page"
Date:

> -----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.