Many thanks, Tom. I wish I had known "\pset null nil" trick. It would have saved a few unnecessary emails.
Regards, Tena Sakai tsa...@gallo.ucsf.edu -----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wed 7/1/2009 10:42 AM To: Tena Sakai Cc: Rob Sargent; pgsql-sql@postgresql.org Subject: Re: [SQL] it's not NULL, then what is it? "Tena Sakai" <tsa...@gallo.ucsf.edu> 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