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

Can't use NULL in IN conditional?

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Can't use NULL in IN conditional?
Date: 2000-12-11 07:49:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Charles Tassell (ctassell(at)isn(dot)net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Can't use NULL in IN conditional?

Long Description
I don't know if this is a "feature" that comes alogn with NULL values, or somethign I'm doing wrong, but I can't seem to search for the NULL value via a WHERE xx IN clause.  I've re-written the query to use OR and it works fine then, but not with the IN clause.  This is with Postgres 7.02 on a Linux system (PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66)

Sample Code
CREATE TABLE product_types (
  type_id serial,
  code  text
INSERT INTO product_types (code) VALUES ('0A');
INSERT INTO product_types (code) VALUES (NULL);
-- This works
SELECT type_id, code FROM product_types WHERE code = '0A' OR code = NULL;
-- This doesn't
SELECT type_id, code FROM product_types WHERE code IN ('OA', NULL);

No file was uploaded with this report


pgsql-bugs by date

Next:From: Kevin GilpinDate: 2000-12-11 14:51:35
Subject: CREATE FUNCTION distributors_id_max() RETURNS INT4 AS Bad Timestamp Format thrown by jdbc7.0-1.2.jar
Previous:From: The Hermit HackerDate: 2000-12-10 17:15:34
Subject: Re: Re: [BUGS] 7.1beta1 JDBC Nested cursor problem

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