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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruno Wolff III 2007-01-17 17:40:01 Re: Array handling in libpq
Previous Message Bruce Momjian 2007-01-17 15:46:17 Re: Array handling in libpq