Many thanks, Tom. I wish I had known "\pset null nil" trick. It would have saved a few unnecessary emails.
Regards, Tena Sakai [email protected] -----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: Wed 7/1/2009 10:42 AM To: Tena Sakai Cc: Rob Sargent; [email protected] Subject: Re: [SQL] it's not NULL, then what is it? "Tena Sakai" <[email protected]> writes: >> So they were null, > Yes! >> and null turns out to be a seven-character blank string!? > I don't understand how that happens. Mr Tom Lane > hinted that it might be a bug in sprintf... Well, that was before I read the messages where it turned out that they were actually nulls after all. regards, tom lane
