Re: Prune partitions by ScalarArrayOpExpr with an array parameter (partkey = ANY($1))

po 17. 3. 2025 v 14:28 odesílatel Andrei Lepikhov <lepihov(at)gmail(dot)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
>