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

Since column is boolean, you need a boolean result:

insert into table (column) values (nullif(true,true));

> -----Original Message-----
> From: pgsql-patches-owner(at)postgresql(dot)org
> [mailto:pgsql-patches-owner(at)postgresql(dot)org] On Behalf Of Matt A.
> Sent: Monday, August 22, 2005 3:22 AM
> To: pgsql-bugs(at)postgresql(dot)org; pgsql-patches(at)postgresql(dot)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
>
>