Re: Postgres 9.2.4 "Double Precision" Precision

Adrian, Kevin,

Thank you for the clues. It turns out a java process was added (between
the data source and database) at same time of postgres upgrade. It was the
java process that incorrectly handled the double precision data.

Joanne

On Sat, Sep 14, 2013 at 9:57 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>wrote:

> On 09/14/2013 08:51 AM, Kevin Grittner wrote:
>
>> Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
>>
>> create table float_test (id int, f_fld double precision);
>>> insert into float_test values (1, 6.31);
>>> insert into float_test values (2, 6.32);
>>> select * from float_test ;
>>>
>>> id | f_fld
>>> ----+-------
>>> 1 | 6.31
>>> 2 | 6.32
>>> (2 rows)
>>>
>>
>> If, instead of those inserts I use these:
>>
>> insert into float_test values (1, '6.31');
>> insert into float_test values (1, '6.32');
>> insert into float_test values (1, '6.32'::double precision);
>> insert into float_test values (1, '6.32'::real);
>>
>> I get:
>>
>> id | f_fld
>> ----+------------------
>> 1 | 6.31
>> 1 | 6.32
>> 1 | 6.32
>> 1 | 6.32000017166138
>> (4 rows)
>>
>> Apparently the value is being treated as a real value somewhere.
>>
>
> Interesting, more grist for the mill.
>
>
>
>> --
>> Kevin Grittner
>> EDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>