On Thu, May 22, 2025 at 10:24 PM Bruce Momjian <br...@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
