Pavel Stehule <pavel.steh...@gmail.com> writes: >> Curiously enough, Oracle has it so that || of null arguments treats the >> arguments as empty string. >> >> It's beyond comprehension. >> > what is result of '' || '' ?
Well the result of this is NULL of course (which is the same as '') What's more puzzling is what the answer to 'foo' || NULL is... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers