Re: Get more from indices. - Mailing list pgsql-hackers

Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp> writes:
> (2014/04/10 0:08), Tom Lane wrote:
>> TBH I think that's barely the tip of the iceberg of cases where this
>> patch will get the wrong answer.

>> Also, I don't see it doing anything to check the ordering
>> of multiple index columns

> I think that the following code in index_pathkeys_are_extensible() would
> check the ordering:
> +    if (!pathkeys_contained_in(pathkeys, root->query_pathkeys))
> +        return false;

Hm ... if you're relying on that, then what's the point of the new loop
at all?
        regards, tom lane