Thread: numeric problems

numeric problems

From
"jack"
Date:
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 querywith a
fieldof numeric, for eample NUMERIC (10.2). Followingstaement causes an error such as "Unable to indentify anoperator
'>'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





Re: numeric problems

From
"Paul Ogden"
Date:
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: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of jack
> Sent: Thursday, November 14, 2002 18:22
> To: pgsql-sql@postgresql.org
> 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