Re: request for sql3 compliance for the update command

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