Postgres Pro
Downloads
Home   >   mailing lists

insert into table (column) values (nullif('','')); - Mailing list pgsql-patches

From Matt A.
Subject insert into table (column) values (nullif('',''));
Date
Msg-id 20050821172143.85118.qmail@web35207.mail.mud.yahoo.com
Whole thread Raw
List pgsql-patches
Tree view 
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:

Previous
From: Andrew Dunstan
Date:
Subject: Re: [HACKERS] Proposed patch to getaddrinfo.c to support
Next
From: "John Hansen"
Date:
Subject: Re: insert into table (column) values (nullif('',''));