On Mon, Jul 25, 2011 at 1:05 AM, Joey Adams <joeyadams3.14...@gmail.com> wrote: > Should we mimic IEEE floats and preserve -0 versus +0 while treating > them as equal? Or should we treat JSON floats like numeric and > convert -0 to 0 on input? Or should we do something else? I think > converting -0 to 0 would be a bad idea, as it would violate the > intuitive assumption that JSON can be used to marshal double-precision > floats.
On the other hand, JavaScript's own .toString and JSON.stringify turn -0 into 0, so JSON can't marshal -0 around, anyway (in practice). Now I think turning -0 into 0 would be fine for canonicalizing numbers in json_in. - Joey -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
