Re: bug or feature, || -operator and NULLs

From: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Subject: Re: bug or feature, || -operator and NULLs
Date: 2006-10-18 12:43:30
Message-ID: 45362172.3060101@pooteeweet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Martijn van Oosterhout wrote:

> By following your suggestion we would get the following oddity:
>
> SELECT NULL = '', NULL || 'fisk' = '' || 'fisk';
>
> We would return NULL for the first and true for the second. Surely
> that's not logical?

The problem is really that Oracle does not differntiate properly between
'' and NULL.

regards,
Lukas

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-10-18 12:43:41 Re: +1400 is a valid time zone offset
Previous Message Csaba Nagy 2006-10-18 12:42:02 Re: bug or feature, || -operator and NULLs