UPDATE tuples with a sub-select

Thomas Kellerer <spam_eater@xxxxxxx> · Fri, 07 Nov 2008 11:15:07 +0100

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);

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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general