Thread: 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

Since column is boolean, you need a boolean result:

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

> -----Original Message-----
> From: pgsql-patches-owner@postgresql.org
> [mailto:pgsql-patches-owner@postgresql.org] 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
>
>