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