Bruno Wolff III [mailto:bruno(at)wolff(dot)to] Wrote:
> You only want to use partial indexes when they don't cover
> the whole table. They make sense to enforce uniqueness of a
> column under some condition and when you can save significant
> space (becuase the condition is only satisfied for a small
> fraction of rows).
Yes, I know that,.
I misunderstood the original post as a request for queries NOT to use
indexes where it doesn't match the table contents.
.. John