Re: [BUGS] [PATCHES] insert into table (column) values (nullif('',''));

#1

Since column is boolean, you need a boolean result:

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

Quote:

-----Original Message-----
From: pgsql-patches-owner (AT) postgresql (DOT) org=20
[mailto

gsql-patches-owner (AT) postgresql (DOT) org] On Behalf Of Matt A.
Sent: Monday, August 22, 2005 3:22 AM
To: pgsql-bugs (AT) postgresql (DOT) org; pgsql-patches (AT) postgresql (DOT) org
Subject: [PATCHES] insert into table (column) values (nullif('',''));
=20
insert into table (column) values (nullif('',''));
ERROR: column "column" is of type boolean but expression is=20
of type text.
=20
inserting NULL works. nullif('','') should return NULL if=20
both values are equal? It works in MSSQL.
=20
Is there different function to accomplish a insert
nullif('','') test.=20
=20
Thanks
Matt
=20
=20
=20
=20
=20=09=09
__________________________________________________ __
Start your day with Yahoo! - make it your home page=20
http://www.yahoo.com/r/hs=20
=20=20
=20
---------------------------(end of=20
broadcast)---------------------------
TIP 4: Have you searched our list archives?
=20
http://archives.postgresql.org
=20
=20

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [PATCHES] insert into table (column) values (nullif('',''));

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [PATCHES] insert into table (column) values (nullif('','')); - 08-27-2005 , 12:36 AM