Обсуждение: RE: [SQL] partial indexes (indices)

Поиск
Список
Период
Сортировка

RE: [SQL] partial indexes (indices)

От
Daniel Péder
Дата:
YES!
that's what I'am looking for. But does anybody know HOW ?

-----Original Message-----
> does anybody know anything about subject?
> any hint where can I find documentation ( in standard PSQL manual pages is only short item withou any syntax
description)
> 
> --

Allows you to index only part of a table.  Don't know any more.

-- 
Dan Peder 
dpeder@infoset.cz
http://shop.culture.cz



Re: [SQL] partial indexes (indices)

От
Tom Lane
Дата:
Daniel Péder <dpeder@infoset.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