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

From: "Matt A(dot)" <survivedsushi(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: insert into table (column) values (nullif('',''));
Date: 2005-08-21 17:21:43
Message-ID: 20050821172143.85118.qmail@web35207.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

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

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2005-08-21 20:20:24 Re: PostgreSQL 8.0.3 and Ipv6
Previous Message Tom Lane 2005-08-21 15:08:34 Re: PostgreSQL 8.0.3 and Ipv6