Re: real -> numeric -> real result different through jdbc - Mailing list pgsql-jdbc

From Michael Nacos
Subject Re: real -> numeric -> real result different through jdbc
Date
Msg-id 407fa4640912110922g4afbd5aela91f816cbce75cf8@mail.gmail.com
Whole thread Raw
In response to Re: real -> numeric -> real result different through jdbc  (Michael Nacos <m.nacos@gmail.com>)
List pgsql-jdbc
> surely, it's not just a case of float4 display, type casting seems to be affected, too.

I have run some more tests and I'd like to take this back. The reason our equality tests fail when
extra_float_digits = 2 is this: we are constructing dynamic SQL statements inside a PL/pgSQL
function. The SQL produced is, of course, affected by the textual representation of REALs in effect,
hence the problems we have encountered. Thanks, this is making much more sense now.

Michael

pgsql-jdbc by date:

Previous
From: Michael Nacos
Date:
Subject: Re: real -> numeric -> real result different through jdbc
Next
From: John R Pierce
Date:
Subject: Re: Connection.setReadOnly()