Re: Re: [GENERAL] Trouble with float4 afterupgrading from 6.5.3 to 7.0.2

At 01:40 AM 8/9/00 +1000, Philip Warner wrote:

>This makes me think that some kind of binary dump in pg_dump is probably
>not a bad idea. Has anybody looked at doing a cross-platform binary COPY?
>Or some other way of representing base types - we have <type>in/out maybe
><type>exp/imp (export/import) might be useful to get a portable, lossless
>representation.

Another way to do it is to dump/restore floats in hex, maintaining the
actual binary values.

Conversion to hex, unlike conversion to decimal, is exact (16 is a power
of 2 while 10 is not, to add to your "more knowledge than you want" about
floats!)



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.