Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
