Hi Tom, > What platform are you running on exactly?
It is redhat linux running on Dell hardware. uname -a returns: Linux vixen.egcrc.org 2.6.9-78.0.1.ELsmp #1 SMP Tue Jul 22 18:01:05 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux > And for that matter, what PG version is this? It is 8.3.6. Regards, Tena Sakai [email protected] -----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Tue 6/30/2009 7:17 PM To: Tena Sakai Cc: Edward W. Rouse; [email protected] Subject: Re: [SQL] it's not NULL, then what is it? "Tena Sakai" <[email protected]> writes: >>> My confusion is that if they are real and not null, >>> what are they? Good question. So far as I can see these must be some value that sprintf() is printing as spaces; but not NaN and not Infinity because float4out checks for those first. I would argue that this must be a bug in sprintf. What platform are you running on exactly? And for that matter, what PG version is this? regards, tom lane
