po 17. 3. 2025 v 14:28 odesÃlatel Andrei Lepikhov <lepi...@gmail.com> napsal:
> Hi, > > As I see, initial pruning doesn't work in the case when a > ScalarArrayOpExpr contains a parameter as the RHS of the expression, > like following: > > partkey = ANY($1) > > As colleagues say, it is quite typical to use stored procedures, pass an > array of IDs as a parameter, and use it in a SELECT clause. > > So, here I propose a patch that extends pruning machinery. It is nothing > innovative or complicated, but I'm not sure it is fully operational so > far: it may need some discussion, review and polishing. > > I intended to add it to the next commitfest if this feature makes sense. > +1 Pavel > -- > regards, Andrei Lepikhov >
