Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 032754758DC
	for <pgsql-sql@postgresql.org>; Thu, 14 Nov 2002 21:22:02 -0500 (EST)
Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57])
	by postgresql.org (Postfix) with ESMTP id 2F96E474E42
	for <pgsql-sql@postgresql.org>; Thu, 14 Nov 2002 21:22:00 -0500 (EST)
Received: from jac (bri-ts4-2600-145.tpgi.com.au [203.219.27.145])
	by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id gAF2M2N17241
	for <pgsql-sql@postgresql.org>; Fri, 15 Nov 2002 13:22:02 +1100
Message-ID: <005901c28c4d$c800a0d0$1400a8c0@jac>
From: "jack" <datactrl@tpg.com.au>
To: <pgsql-sql@postgresql.org>
Subject: numeric problems
Date: Fri, 15 Nov 2002 12:21:59 +1000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/222
X-Sequence-Number: 10364

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