[PATCHES] insert into table (column) values (nullif('',''));

2005-08-26 Thread Matt A.
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.

Re: [PATCHES] insert into table (column) values (nullif('',''));

2005-08-26 Thread John Hansen
@postgresql.org Subject: [PATCHES] insert into table (column) values (nullif('','')); 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