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

From: "Matt" <survivedsushi(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1839: insert into table (column) values (nullif('',''));
Date: 2005-08-21 17:17:28
Message-ID: 20050821171728.297D1F0DF7@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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.

Is there different function to accomplish a insert
nullif('','') test.

Thanks
Matt

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2005-08-22 14:17:47 Re: BUG #1839: insert into table (column) values (nullif('',''));
Previous Message Michael Fuhr 2005-08-21 03:16:15 Re: CSV import issue - please help