From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | Matt <survivedsushi(at)yahoo(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1839: insert into table (column) values (nullif('','')); |
Date: | 2005-08-22 14:17:47 |
Message-ID: | 20050822071618.L87514@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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).
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-22 14:23:46 | Re: BUG #1838: IndexSupportInitialze |
Previous Message | Matt | 2005-08-21 17:17:28 | BUG #1839: insert into table (column) values (nullif('','')); |