Re: BUG #1839: insert into table (column) values (nullif('',''));

On Sun, 21 Aug 2005, Matt wrote:

>
> The following bug has been logged online:
>
> Bug reference: 1839
> Logged by: Matt
> Email address: survivedsushi(at)yahoo(dot)com
> PostgreSQL version: 8.0.3
> Operating system: linux
> Description: insert into table (column) values (nullif('',''));
> Details:
>
> insert into table (column) values (nullif('',''));
> ERROR: column "column" is of type boolean but
> expression is of type text.
>
> inserting NULL works. nullif('','') should return NULL
> if both values are equal? It works in MSSQL.

It does return a NULL AFAICS, however it looks like it returns a NULL cast
to a textual type (since if they were different, it would return its first
argument according to the docs).