BUG #1839: insert into table (column) values (nullif('','')); - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1839
Logged by:          Matt
Email address:      survivedsushi@yahoo.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

pgsql-bugs by date:

Previous
From: Bernard
Date:
Subject: CSV import issue - please help
Next
From: Tom Lane
Date:
Subject: Re: BUG #1838: IndexSupportInitialze