Re: Replace IN VALUES with ANY in WHERE clauses during optimization

Peter Geoghegan <pg@bowt.ie>

From: Peter Geoghegan <pg@bowt.ie>

To: Alena Rybakina <a.rybakina@postgrespro.ru>

Cc: Andres Freund <andres@anarazel.de>, Alexander Korotkov <aekorotkov@gmail.com>, Andrei Lepikhov <lepihov@gmail.com>, Ivan Kush <ivan.kush@tantorlabs.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Laurenz Albe <laurenz.albe@cybertec.at>

Date: 2025-04-04T15:33:56Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Stabilize regression test from c0962a113.
- 3ba2cdaa4541 18.0 landed
Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate
- c0962a113d1f 18.0 landed
Extract make_SAOP_expr() function from match_orclause_to_indexcol()
- d48d2e2dc8be 18.0 landed

On Fri, Apr 4, 2025 at 11:19 AM Alena Rybakina
<a.rybakina@postgrespro.ru> wrote:
> I fixed it - changed the tables and didn't use system tables.

Is somebody going to commit this soon? Alexander?


-- 
Peter Geoghegan