On Thu, May 22, 2025 at 10:24 PM Bruce Momjian <bruce@momjian.us> wrote:
> I see your point that we are not defining what this does. I went with
> the attached text.
You propose the wording is "This allows muti-column btree indexes to
be used by queries that only reference the second or later indexed
columns".
I think that your wording is a big improvement. I personally would
have emphasized the absence of a "=" condition, rather than the
presence of another condition on a later column, since there are cases
where the first column is referenced but skip scan can still be used
(e.g., when there one or more inequalities on the first column, plus a
"=" condition on the second column). I can live with this wording,
though.
Thanks
--
Peter Geoghegan
