Re: no partition pruning when partitioning using array type - Mailing list pgsql-hackers

On 2018/07/11 4:48, Alvaro Herrera wrote:
> On 2018-Jul-10, Alvaro Herrera wrote:
> 
>> alvherre=# explain update p set a = a || a where a = '{1}';
>>                         QUERY PLAN                        
>> ──────────────────────────────────────────────────────────
>>  Update on p  (cost=0.00..54.03 rows=14 width=38)
>>    Update on p1
>>    Update on p2
>>    ->  Seq Scan on p1  (cost=0.00..27.02 rows=7 width=38)
>>          Filter: (a = '{1}'::integer[])
>>    ->  Seq Scan on p2  (cost=0.00..27.02 rows=7 width=38)
>>          Filter: (a = '{1}'::integer[])
>> (7 filas)
>>
>> Because UPDATE uses the predtest.c prune code, not partprune.  So it's
>> not just some ruleutils beautification.
> 
> I added this test, modified some comments, and pushed.
> 
> Thanks for the patch.

Thank you for committing.

Regards,
Amit