The following bug has been logged online: Bug reference: 1839 Logged by: Matt Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster