pg_dump and psql disagree on numerical precision (powerpc)

From: Christof Petig <christof(at)petig-baender(dot)de>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dump and psql disagree on numerical precision (powerpc)
Date: 2003-11-14 09:55:42
Message-ID: 3FB4A69E.2050705@petig-baender.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I didn't believe it at first:

create table test ( x double precision);

insert into test values (0.3);

test=# select * from test;
x
-----
0.3

--
-- Data for TOC entry 3 (OID 53248)
-- Name: test; Type: TABLE DATA; Schema: public; Owner: christof
--
COPY test (x) FROM stdin;
0.29999999999999999
\.

psql --version
psql (PostgreSQL) 7.4RC1

\set
VERSION = 'PostgreSQL 7.4RC1 on powerpc-unknown-linux-gnu, compiled by
GCC powerpc-linux-gcc (GCC) 3.3.2 (Debian)'

pg_dump --version
pg_dump (PostgreSQL) 7.4RC1

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-11-14 14:50:32 Re: pg_dump and psql disagree on numerical precision (powerpc)
Previous Message Tom Lane 2003-11-13 15:43:07 Re: