Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA39553 for ; Thu, 23 Sep 1999 17:35:55 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id RAA15821; Thu, 23 Sep 1999 17:34:46 -0400 (EDT) To: =?iso-8859-2?Q?Daniel_P=E9der?= cc: "pgsql-sql@hub.org" , pgsql-hackers@postgreSQL.org Subject: Re: [SQL] partial indexes (indices) In-reply-to: Your message of Thu, 23 Sep 1999 19:10:57 +0200 <01BF05F7.5E4F9CC0@Dan> Date: Thu, 23 Sep 1999 17:34:46 -0400 Message-ID: <15819.938122486@sss.pgh.pa.us> From: Tom Lane =?iso-8859-2?Q?Daniel_P=E9der?= writes: > YES! > that's what I'am looking for. But does anybody know HOW ? > Allows you to index only part of a table. Don't know any more. It seems to be disabled in gram.y for some reason (no WHERE clause in CREATE INDEX anymore), which is odd since there's still an awful lot of code to support the feature elsewhere. Anyone know who took this out and why? regards, tom lane