X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 49C349FB2AE for ; Thu, 13 Jul 2006 17:20:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 54594-05 for ; Thu, 13 Jul 2006 17:20:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 56F489FB2AC for ; Thu, 13 Jul 2006 17:20:32 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k6DKKQ81006106 for ; Thu, 13 Jul 2006 17:20:26 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k6DK3xjv002893 for pgsql-admin@postgresql.org; Thu, 13 Jul 2006 17:03:59 -0300 (ADT) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: 8.1 Unique Index Issue/Bug??? Date: Thu, 13 Jul 2006 15:15:18 -0400 Organization: cbbrowne Computing Inc Lines: 12 Message-ID: <60wtahpb95.fsf@dba2.int.libertyrms.com> References: <1d219a6f0607130740g7fe13967t48c77a64fde977aa@mail.gmail.com> <44B6949A.7070209@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:sUHULyLugedc4C5i77h1ZochyTE= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/100 X-Sequence-Number: 22346 jd@commandprompt.com ("Joshua D. Drake") writes: > That is why IS NULL can be placed in a unique index because it isn't > actually there (in the theorectical sense). In effect, NULL is not actually a value. -- (reverse (concatenate 'string "gro.mca" "@" "enworbbc")) http://www.ntlug.org/~cbbrowne/sap.html "Has anyone ever thought about the fact that in general, the only web sites that are consistently making money are the ones dealing in pornography? This brings new meaning to the term, "obscene profits". :)" -- Paul Robinson