Dmitry,

> As expected, it does use the index.
>
> > And if this test does use the index, then you'll need
> > a test with ddl and possibly data from the original author.
>
> This is what I'm asking for :-)
>

Right. And perhaps the author can think about the differences between
the case that appears not to work and this one. And what part of relational
theory allows partial matches on keys.

Sigh,

Ann


[Non-text portions of this message have been removed]