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: (view raw, whole thread or download thread mbox)
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. 


Start your day with Yahoo! - make it your home page 

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-2017 The PostgreSQL Global Development Group