Thread: RE: [SQL] partial indexes (indices)
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
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