Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4679E475CE5 for ; Mon, 4 Nov 2002 09:35:15 -0500 (EST) Received: from technovell.com (213-97-10-232.uc.nombres.ttd.es [213.97.10.232]) by postgresql.org (Postfix) with ESMTP id 4EC87475CC4 for ; Mon, 4 Nov 2002 09:35:14 -0500 (EST) Received: from technovell.com pgsql@technovell.com [195.55.249.227] by technovell.com with Novell NIMS $Revision: 2.88.1.1 $ on Linux; Mon, 04 Nov 2002 15:34:50 +0100 Message-ID: <3DC685B0.D92E88E3@technovell.com> Date: Mon, 04 Nov 2002 15:35:28 +0100 From: Terry Yapt X-Mailer: Mozilla 4.79 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Bruno Wolff III Cc: pgsql-sql@postgresql.org Subject: Re: Comparing Numeric and Double Precision (float8).. References: <3DC62BB2.72FC66C8@technovell.com> <20021104134515.GA5617@wolff.to> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/44 X-Sequence-Number: 10186 Great.... I don't know if my customers can wait until 7.3 official release, but I'll try to distract them a bit... :-\ Thanks a lot Bruno... Bruno Wolff III wrote: > > On Mon, Nov 04, 2002 at 09:11:30 +0100, > Terry Yapt wrote: > > > > When I compare a numeric(x,0) field with a float8 field I have an error > > on PostgreSQL what I didn't have with Oracle. I mean: > > > > CREATE test (one numeric(2,0)); > > > > SELECT * FROM test WHERE one = 1.00000; > > With 7.3b3 the above works after correcting the create statement. > bruno=> create table test (one numeric(2,0)); > CREATE TABLE > bruno=> SELECT * FROM test WHERE one = 1.00000; > one > ----- > (0 rows)