Re: [PATCH] Add support function for containment operators
Laurenz Albe <laurenz.albe@cybertec.at>
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Kim Johan Andersson <kimjand@kimmet.dk>, pgsql-hackers@lists.postgresql.org
Date: 2023-07-07T11:20:41Z
Lists: pgsql-hackers
I wrote: > You implement both "SupportRequestIndexCondition" and "SupportRequestSimplify", > but when I experimented, the former was never called. That does not > surprise me, since any expression of the shape "expr <@ range constant" > can be simplified. Is the "SupportRequestIndexCondition" branch dead code? > If not, do you have an example that triggers it? I had an idea about this: So far, you only consider constant ranges. But if we have a STABLE range expression, you could use an index scan for "expr <@ range", for example Index Cond (expr >= lower(range) AND expr < upper(range)). Yours, Laurenz Albe
Commits
-
Add planner support functions for range operators <@ and @>.
- 075df6b2080b 17.0 landed