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

On 3/17/25 14:28, Andrei Lepikhov wrote: 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 ID

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

po 17. 3. 2025 v 14:28 odesílatel Andrei Lepikhov 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 pro

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

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 c