Le 26 févr. 2010 à 17:11, Tom Lane a écrit : > =?iso-8859-1?Q?R=E9mi_Zara?= <remi_z...@mac.com> writes: >> I've tried patch 1 and 2, but they do not work. The fact is that the code is >> not used in the backend, because strtod("NaN", endptr) works. >> (isnan(strtod("NaN", endptr)) is true). > > Hmm. So what do you get from > SELECT 'nan'::numeric::float8; > on that machine? That should exercise the backend's version of > get_float8_nan(). >
regression=# select 'nan'::numeric::float8; float8 ---------- Infinity (1 row) So it is indeed the same behavior. Maybe that should be added to the regression tests. So what's the best way to workaround the bug in NetBSD/mips ? (nan(""), (0.0/0.0), strtod("nan", null) ?) Regards, Rémi Zara -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers