Greg Stark wrote:
>
> 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
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
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
