Re: [SQL] partial indexes (indices)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Péder <dpeder(at)infoset(dot)cz>
Cc: "pgsql-sql(at)hub(dot)org" <pgsql-sql(at)hub(dot)org>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [SQL] partial indexes (indices)
Date: 1999-09-23 21:34:46
Message-ID: 15819.938122486@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

=?iso-8859-2?Q?Daniel_P=E9der?= <dpeder(at)infoset(dot)cz> 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-09-23 21:38:36 Re: [HACKERS] VIEW definitions broken in 6.5.0
Previous Message Tom Lane 1999-09-23 21:27:37 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-09-23 21:56:18 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question
Previous Message Tom Lane 1999-09-23 21:27:37 Re: [SQL] Re: [HACKERS] SELECT DISTINCT question