Re: [GENERAL] index selection by query planner

2005-06-21 Thread Tom Lane
Rohit Gaddi <[EMAIL PROTECTED]> writes: > I have a table with two indices on the same column, one of which is a partial > index. I would like the query planner to use the partial index whenever the > query condition lies in the range of the partial index as it would yield > better performance. I

[GENERAL] index selection by query planner

2005-06-21 Thread Rohit Gaddi
Hi,   I have a table with two indices on the same column, one of which is a partial index. I would like the query planner to use the partial index whenever the query condition lies in the range of the partial index as it would yield better performance. Is there any way to enforce the ordering for