On 09/13/2013 12:36 PM, Joanne Salerno - NOAA Federal wrote:
> Arian,
>
> It is a single database . Postgres was upgraded from 8.2.6 to 9.2.4...
> the database contents was not altered in upgrade, that is a 8.2.6 dump
> was not created then uploaded to 9.2.4.
>
> Perhaps handling of double precision, changed from 8.2.6 to 9.2.4 ?
To follow up, I don't think that is the case. By way of example, granted
on a 9.3 instance:
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)
A couple of questions:
How is the data entered into the database?
Just wondering if there was any client side changes along with the
database change?
>
> Joanne
--
Adrian Klaver
adrian.klaver@gmail.com