Re: BUG #6702: SELECT Query on INDEX

On Fri, Jun 22, 2012 at 01:19:50AM +0000, alokrawat0212@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6702
> Logged by:          Alok Rawat
> Email address:      alokrawat0212@gmail.com
> PostgreSQL version: 9.1.0
> Operating system:   WIN 7
> Description:
>
> Hello all,
>
> I created a Index in postgres.Now i want to fire select query in this Index
> and check data.
This is not a bug. For general questions regarding PostgreSQL, please
use the pgsql-general mailing list.

> Please tell me how to perform this???
PostgreSQL will automatically use your index when querying the table
that has that index, when appropriate. One does not query an index
directly. You might want to understand how to use EXPLAIN to see if your
index is being utilized. See the documentation at:
http://www.postgresql.org/docs/9.1/static/indexes.html
http://www.postgresql.org/docs/9.1/static/using-explain.html

>
> Thanks in advance,
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-Ryan Kelly