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).