Re: float formating with xx.00

"Dann Corbit" <DCorbit@connx.com> writes:
> Now, this is 7.1.3.  Don't know if 7.4 (or other flavors) behave
> differently.

Quite differently ... in 7.2 and later:

regression=# create table test2(foo numeric);
CREATE
regression=# insert into test2 values (10.00000000000000000000001);
INSERT 148451 1
regression=# insert into test2 values (10.000000000000000000000000000000000000000000000000000000000000000000001);
INSERT 148452 1
regression=# select * from test2;
                                   foo
--------------------------------------------------------------------------
                                               10.00000000000000000000001
 10.000000000000000000000000000000000000000000000000000000000000000000001
(2 rows)

regression=#


            regards, tom lane