Re: bug or feature, || -operator and NULLs - Mailing list 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