On Fri, Jun 22, 2012 at 01:19:50AM +0000, alokrawat0...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 6702 > Logged by: Alok Rawat > Email address: alokrawat0...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
