<p><font size="2">Hi Tom,<br /><br /> > What platform are you running on exactly?<br /><br /> It is redhat linux
runningon Dell hardware.<br /> uname -a returns:<br /> Linux vixen.egcrc.org 2.6.9-78.0.1.ELsmp #1 SMP Tue Jul 22
18:01:05EDT 2008 x86_64 x86_64 x86_64 GNU/Linux<br /><br /> > And for that matter, what PG version is this?<br /><br
/>It is 8.3.6.<br /><br /> Regards,<br /><br /> Tena Sakai<br /> tsakai@gallo.ucsf.edu<br /><br /> -----Original
Message-----<br/> From: Tom Lane [<a href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]<br /> Sent: Tue
6/30/20097:17 PM<br /> To: Tena Sakai<br /> Cc: Edward W. Rouse; pgsql-sql@postgresql.org<br /> Subject: Re: [SQL] it's
notNULL, then what is it?<br /><br /> "Tena Sakai" <tsakai@gallo.ucsf.edu> writes:<br /> >>> My
confusionis that if they are real and not null,<br /> >>> what are they?<br /><br /> Good question. So far as
Ican see these must be some value that<br /> sprintf() is printing as spaces; but not NaN and not Infinity because<br
/>float4out checks for those first. I would argue that this must be<br /> a bug in sprintf. What platform are you
runningon exactly? And<br /> for that matter, what PG version is this?<br /><br /> regards,
tomlane<br /><br /></font>