Reply-To: <pogden@claresco.com>
From: "Paul Ogden" <pogden@claresco.com>
To: "jack" <datactrl@tpg.com.au>, <pgsql-sql@postgresql.org>
Subject: Re: numeric problems
Date: Thu, 14 Nov 2002 18:36:07 -0800
Message-ID: <NAEOJBHEEOEHNNICGFADGEJODFAA.pogden@claresco.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
In-Reply-To: <005901c28c4d$c800a0d0$1400a8c0@jac>
Importance: Normal

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