Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> UPDATE totals SET
> xmax = ss.xmax, xmin = ss.xmin, ...
> FROM
> (SELECT groupid, max(x) AS xmax, ... FROM details GROUP BY groupid) ss
> WHERE groupid = ss.groupid;
>
...
>
> Of course this syntax isn't standard either ... but we already have it.
Did this patch ever make it in? It's not documented in the 8.0 documentation
for UPDATE at:
http://www.postgresql.org/docs/8.0/interactive/dml-update.html
--
greg