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 ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org