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 6: explain analyze is your friend

Reply via email to