Greg Stark wrote:
>
> Tom Lane <tgl@sss.pgh.pa.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
It is documented only in the UPDATE manual page because it is fairly exotic:
http://www.postgresql.org/docs/8.0/interactive/sql-update.html
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073