Re: [SQL] Comparing Numeric and Double Precision (float8)..

2002-11-04 Thread Terry Yapt
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 <[EMAIL PROTECTED]> wrote: > > > > When I compare a numeric(x,0) field

Re: [SQL] Comparing Numeric and Double Precision (float8)..

2002-11-04 Thread Bruno Wolff III
On Mon, Nov 04, 2002 at 09:11:30 +0100, Terry Yapt <[EMAIL PROTECTED]> 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.0; W

[SQL] Comparing Numeric and Double Precision (float8)..

2002-11-04 Thread Terry Yapt
Hello all, i DON'T know what is the proper forum to throw this question and I must to insist in this "feature". Sorry. I have a lot of tables from Oracle 8i Databases with a lot of columns with numeric(x,0) definition. Ok.. I am traslating my oracle tables to PostgreSQL tables. But I am having