From: Paul Ogden <pogden@claresco.com>
To: jack <datactrl@tpg.com.au>
To: pgsql-sql@postgresql.org
Subject: Re: numeric problems
Date: Thu, 14 Nov 2002 18:36:07 -0800
Message-ID: <NAEOJBHEEOEHNNICGFADGEJODFAA.pogden@claresco.com> (raw)
In-Reply-To: <005901c28c4d$c800a0d0$1400a8c0@jac>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pogden@claresco.com, datactrl@tpg.com.au
Subject: Re: numeric problems
In-Reply-To: <NAEOJBHEEOEHNNICGFADGEJODFAA.pogden@claresco.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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