From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
Cc: | map(at)inter-resa(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: float formating with xx.00 |
Date: | 2003-07-04 03:20:35 |
Message-ID: | 12480.1057288835@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Dann Corbit" <DCorbit(at)connx(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-07-04 04:00:45 | Re: Various serverlog messages |
Previous Message | Mark | 2003-07-04 03:16:52 | Re: float formating with xx.00 |