On Fri, Nov 07, 2008 at 11:15:07AM +0100, Thomas Kellerer wrote: > Hi, > > are there any plans to support updating a tuple using a sub-select in one of > the future versions. > > e.g, something like: > > UPDATE report_table > SET (order_count,order_value) = (SELECT count(*), sum(amount) > FROM order o > WHERE o.customer_id = > report_table.customer_id);
What about:
UPDATE report_table SET order_count = s_count, order_value = s_value
FROM (SELECT count(*) AS s_count, sum(amount) AS s_value FROM order o
WHERE o.customer_id = report_table.customer_id)
Its untested, but I think, it must works like this.
> I know it's currently not possible (so we need to revert to two sub-selects)
> but I was wondering if this somewhere on the "roadmap"
>
> Regards
> Thomas
Regards,
Gerhard
signature.asc
Description: Digital signature
