Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: it's not NULL, then what is it?


  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
  • Cc: "Edward W. Rouse" <erouse(at)comsquared(dot)com>, pgsql-sql(at)postgresql(dot)org
  • Subject: Re: it's not NULL, then what is it?
  • Date: Tue, 30 Jun 2009 22:17:41 -0400
  • Message-id: <1145.1246414661@sss.pgh.pa.us> <text/plain>

"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> 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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group