pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

numeric problems
2+ messages / 2 participants
[nested] [flat]

* numeric problems
@ 2002-11-15 02:21  jack <datactrl@tpg.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: jack @ 2002-11-15 02:21 UTC (permalink / raw)
  To: pgsql-sql

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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: numeric problems
@ 2002-11-15 02:36  Paul Ogden <pogden@claresco.com>
  parent: jack <datactrl@tpg.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Paul Ogden @ 2002-11-15 02:36 UTC (permalink / raw)
  To: jack <datactrl@tpg.com.au>; pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-11-15 02:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-15 02:21 numeric problems jack <datactrl@tpg.com.au>
2002-11-15 02:36 ` Paul Ogden <pogden@claresco.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox