pg_dump and psql disagree on numerical precision (powerpc) - Mailing list pgsql-bugs

From Christof Petig
Subject pg_dump and psql disagree on numerical precision (powerpc)
Date
Msg-id 3FB4A69E.2050705@petig-baender.de
Whole thread Raw
Responses Re: pg_dump and psql disagree on numerical precision (powerpc)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re:
Next
From: Tom Lane
Date:
Subject: Re: pg_dump and psql disagree on numerical precision (powerpc)