Numeric Problem - Mailing list pgadmin-support

From jack
Subject Numeric Problem
Date
Msg-id 005301c28b81$1f87c9f0$1400a8c0@jac
Whole thread Raw
List pgadmin-support
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


pgadmin-support by date:

Previous
From: phaddon@mail.formstar.com (Paul)
Date:
Subject: Data Migration Wizard & FoxPro memo - revisited
Next
From: "Savita"
Date:
Subject: Urgent- pgAdmin II problem