Specifying a index - Mailing list pgsql-general

From lima_caetano@yahoo.com.br (Marcio Caetano)
Subject Specifying a index
Date
Msg-id 6e15fe24.0402030704.ae81a6b@posting.google.com
Whole thread Raw
Responses Re: Specifying a index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello !

Consider the examples bellow:

1- I create a table named TBA with columns ( A int , B char(10) )
2- I create an B-Tree index named IDXA using the column A
3- I create an GIST (or other) index named IDXB using the column A

So, I ask you:

Is it possible specify which index (IDXA or IDXB) my SELECT will use in a query ?
If so, how ?

Thanks in advance.

Marcio Caetano.

pgsql-general by date:

Previous
From: lima_caetano@yahoo.com.br (Marcio Caetano)
Date:
Subject: Multicolumn Indexing using R-Tree
Next
From: Rens Admiraal
Date:
Subject: BLOB problem