Re: UPDATE tuples with a sub-select

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