On Mon, Feb 16, 2009 at 02:35:54PM +0100, Pavel Stehule wrote: > attachment contains module that transform every empty string to null.
Why would anyone ever want to do this? This would appear to break all sorts of things in very non-obvious ways: SELECT CASE s WHEN '' THEN 'empty string' ELSE s END FROM foo; UPDATE foo SET s = NULL WHERE s = ''; would no longer do the expected thing. It would only do the expected thing (in my eyes) when strings of zero length were actually being inserted into the database. Like: INSERT INTO foo (s) VALUES (''); UPDATE foo SET s = '' WHERE s = 'empty string'; Or am I missing something obvious? -- Sam http://samason.me.uk/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers