Horton
Menu

Re: NaN/Inf fix for ECPG

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rémi Zara <remi_zara@mac.com>
Cc: Boszormenyi Zoltan <zb@cybertec.at>, Michael Meskes <meskes@postgresql.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-02-26T16:11:31Z
Lists: pgsql-hackers 
=?iso-8859-1?Q?R=E9mi_Zara?= <remi_zara@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().

			regards, tom lane