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

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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Partitioned tables not using index for min and max 8.2.7?
Next
From: Tim Haak
Date:
Subject: Re: Partitioned tables not using index for min and max 8.2.7?