[GENERAL] covering indexes?

2009-02-12 Thread Kevin Kempter 
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...

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] covering indexes?

2009-02-12 Thread Tom Lane 
Kevin Kempter kev...@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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general