Since column is boolean, you need a boolean result: insert into table (column) values (nullif(true,true));
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Matt A. > Sent: Monday, August 22, 2005 3:22 AM > To: pgsql-bugs@postgresql.org; pgsql-patches@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? 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 > > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
