Re: Postgres 9.2.4 "Double Precision" Precision

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