Postgres Pro
Downloads
Home   >   mailing lists

BUG #1839: insert into table (column) values (nullif('','')); - Mailing list pgsql-bugs

From Matt
Subject BUG #1839: insert into table (column) values (nullif('',''));
Date
Msg-id 20050821171728.297D1F0DF7@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1839: insert into table (column) values (nullif('',''));  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: BUG #1839: insert into table (column) values (nullif('',''));  (Michael Fuhr <mike@fuhr.org>)
Re: BUG #1839: insert into table (column) values (nullif('',''));  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1839
Logged by:          Matt
Email address:      survivedsushi@yahoo.com
PostgreSQL version: 8.0.3
Operating system:   linux
Description:        insert into table (column) values (nullif('',''));
Details:

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

pgsql-bugs by date:

Previous
From: Bernard
Date:
Subject: CSV import issue - please help
Next
From: Tom Lane
Date:
Subject: Re: BUG #1838: IndexSupportInitialze