Pavel Stehule <pavel.stehule@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'sPostgreSQL training!