"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