Thread: covering indexes?

Hi all;

I saw in the 8.1 release notes that a bug fix for covering index logic was
included. Can anyone point me to documentation on how to get PostgreSQL to
take advantage of a covering index (i.e. the query will return data only from
the index with no need to hit the table) ?


Thanks in advance...

Kevin Kempter <kevink@consistentstate.com> writes:
> I saw in the 8.1 release notes that a bug fix for covering index logic was
> included.

I don't know what you thought you read, but there are no covering
indexes in Postgres.

            regards, tom lane