X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id F0634925754 for ; Sun, 25 May 2003 18:59:13 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 61370-09 for ; Sun, 25 May 2003 18:59:12 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 32AE892562F for ; Sun, 25 May 2003 18:59:12 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4PMx4U6016275; Sun, 25 May 2003 18:59:04 -0400 (EDT) To: Josh Berkus Cc: pgsql-sql@postgresql.org Subject: Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4 In-reply-to: <200305251511.47341.josh@agliodbs.com> References: <200305251511.47341.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Sun, 25 May 2003 15:11:47 -0700" Date: Sun, 25 May 2003 18:59:04 -0400 Message-ID: <16274.1053903544@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/490 X-Sequence-Number: 13655 Josh Berkus writes: > I'm updating Joy of Index, and I wanted to clear something up. In 7.3.3, and > in 7.4 CVS, will IS NOT NULL queries use a regular index No. There is no infrastructure that would make this possible. regards, tom lane