Skip site navigation (1) Skip section navigation (2)

Re: Array handling in libpq

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Joris van Zwieten <vanzwieten(at)stcorp(dot)nl>
Cc: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Array handling in libpq
Date: 2007-01-17 17:20:59
Message-ID: 20070117172059.GA13308@wolff.to (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Wed, Jan 17, 2007 at 09:45:09 +0100,
  Joris van Zwieten <vanzwieten(at)stcorp(dot)nl> 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).

In response to

Responses

pgsql-interfaces by date

Next:From: Bruno Wolff IIIDate: 2007-01-17 17:40:01
Subject: Re: Array handling in libpq
Previous:From: Bruce MomjianDate: 2007-01-17 15:46:17
Subject: Re: Array handling in libpq

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group