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

UNIQUE not honoured for NULL

From: David Newall <davidn-postgres(at)rebel(dot)net(dot)au>
To: PostgreSQL bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: UNIQUE not honoured for NULL
Date: 2004-07-06 10:40:51
Message-ID: 1089110449.5002.16.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
PostgreSQL version:  7.4.3 (RPMs from ftp.au.postgresql.org)

Operating Sysem: Fedora Core 1

CREATE TABLE t(i integer UNIQUE);
INSERT INTO t VALUES (null);
INSERT INTO t VALUES (null);
SELECT coalesce(i,-999) FROM t;
 coalesce
----------
     -999
     -999
(2 rows)



Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-07-06 13:37:59
Subject: Re: [SQL] Immutable function in index
Previous:From: David NewallDate: 2004-07-06 09:26:31
Subject: Can't join on null values

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