Re: Use of additional index columns in rows filtering - Mailing list pgsql-hackers

Peter Geoghegan <pg@bowt.ie> writes:
> On Mon, Jul 24, 2023 at 10:36 AM Jeff Davis <pgsql@j-davis.com> wrote:
>> Could we start out conservatively and push down as an Index Filter
>> unless there is some other clause ahead of it that can't be pushed
>> down? That would allow users to have some control by writing clauses in
>> the desired order or wrapping them in functions with a declared cost.

> I'm a bit concerned about cases like the one I described from the
> regression tests.

Please do not put in any code that assumes that restriction clause
order is preserved, or encourages users to think it is.  There are
already cases where that's not so, eg equivalence clauses tend to
get shuffled around.

            regards, tom lane