Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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 
 

pgsql-patches by date

Next:From: Andrew DunstanDate: 2005-08-21 20:20:24
Subject: Re: PostgreSQL 8.0.3 and Ipv6
Previous:From: Tom LaneDate: 2005-08-21 15:08:34
Subject: Re: PostgreSQL 8.0.3 and Ipv6

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group