Re: update syntax

chester c young wrote:
> how in pgsql do you do Oracle's
> 
> update t1 set ( c2, c3 ) =
> ( select c2, c3 from t1 where t1.c1 = t2.c1 );

Well, because we have FROM in UPDATE:
UPDATE t1 SET c2 = t2.c2, c3 = t2.c3FROM t1 t2WHERE t1.c1 = t2.c1;

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026