<p><font size="2">Many thanks, Tom.<br /><br /> I wish I had known "\pset null nil" trick.<br /> It would have saved a
fewunnecessary emails.<br /><br /> Regards,<br /><br /> Tena Sakai<br /> tsakai@gallo.ucsf.edu<br /><br /><br />
-----OriginalMessage-----<br /> From: Tom Lane [<a href="mailto:tgl@sss.pgh.pa.us">mailto:tgl@sss.pgh.pa.us</a>]<br />
Sent:Wed 7/1/2009 10:42 AM<br /> To: Tena Sakai<br /> Cc: Rob Sargent; pgsql-sql@postgresql.org<br /> Subject: Re:
[SQL]it's not NULL, then what is it?<br /><br /> "Tena Sakai" <tsakai@gallo.ucsf.edu> writes:<br /> >> So
theywere null,<br /><br /> > Yes!<br /><br /> >> and null turns out to be a seven-character blank string!?<br
/><br/> > I don't understand how that happens. Mr Tom Lane<br /> > hinted that it might be a bug in
sprintf...<br/><br /> Well, that was before I read the messages where it turned out that they<br /> were actually nulls
afterall.<br /><br /> regards, tom lane<br /><br /></font>