Re: it's not NULL, then what is it? - Mailing list pgsql-sql

From Tom Lane
Subject Re: it's not NULL, then what is it?
Date
Msg-id 1145.1246414661@sss.pgh.pa.us
Whole thread Raw
In response to Re: it's not NULL, then what is it?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-sql
"Tena Sakai" <tsakai@gallo.ucsf.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


pgsql-sql by date:

Previous
From: "Tena Sakai"
Date:
Subject: Re: it's not NULL, then what is it?
Next
From: "Tena Sakai"
Date:
Subject: Re: it's not NULL, then what is it?