Re: Delete/update with limit

On Tue, 2007-07-24 at 18:19, Tom Lane wrote:
> [ thinks for a bit ... ] Actually, you can do it as of 8.2 or so,
> by abusing the ScalarArrayOp stuff: turn the subquery into an array.
> An example in the regression database:
>
> regression=# explain update tenk1 set ten=ten+1
> regression-# where ctid = any (array(select ctid from tenk1 limit 10));
> QUERY PLAN
> -------------------------------------------------------------------------
> Tid Scan on tenk1 (cost=0.46..40.71 rows=10 width=250)
> TID Cond: (ctid = ANY ($0))
> InitPlan
> -> Limit (cost=0.00..0.46 rows=10 width=6)
> -> Seq Scan on tenk1 (cost=0.00..458.00 rows=10000 width=6)
> (5 rows)
>
> It even seems to get the cost estimate right...

Cool, I will use this then (we do have the relevant DB on 8.2). It would
still be nice to have it work directly...

Thanks,
Csaba.