Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id EC6389FB22C for ; Wed, 17 Jan 2007 13:21:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 79333-02 for ; Wed, 17 Jan 2007 13:21:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 4CF8F9FB22A for ; Wed, 17 Jan 2007 13:21:04 -0400 (AST) Received: (qmail 21191 invoked by uid 500); 17 Jan 2007 17:20:59 -0000 Date: Wed, 17 Jan 2007 11:20:59 -0600 From: Bruno Wolff III To: Joris van Zwieten Cc: "Jeroen T. Vermeulen" , Bruce Momjian , pgsql-interfaces@postgresql.org Subject: Re: Array handling in libpq Message-ID: <20070117172059.GA13308@wolff.to> Mail-Followup-To: Bruno Wolff III , Joris van Zwieten , "Jeroen T. Vermeulen" , Bruce Momjian , pgsql-interfaces@postgresql.org References: <200701170346.l0H3kBd23330@momjian.us> <5050.125.24.240.25.1169016593.squirrel@webmail.xs4all.nl> <54258.192.87.1.229.1169023509.squirrel@control.prolocation.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <54258.192.87.1.229.1169023509.squirrel@control.prolocation.net> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/32 X-Sequence-Number: 6410 On Wed, Jan 17, 2007 at 09:45:09 +0100, Joris van Zwieten wrote: > > Thanks for your replies. This is good to know, although one worry remains > and that is loss of precision in the conversion of double to string. But > this could probably always be solved by using enough digits in the > conversion, right? There is a GUC variable (extra_float_digits) for doing this. Setting it to 2 will give enough extra decimal places that you should get back the same binary representation (on the same architecture). This is automatically used in some cases (e.g. pgdump).