Postgres Pro
Downloads
Home   >   mailing lists

update syntax - Mailing list pgsql-sql

From chester c young
Subject update syntax
Date
Msg-id 20020127001845.26972.qmail@web12701.mail.yahoo.com
Whole thread Raw
Responses Re: update syntax  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
how in pgsql do you do Oracle's

update t1 set ( c2, c3 ) =
( select c2, c3 from t1 where t1.c1 = t2.c1 );

thanks
chester

__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com

pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: interval and timestamp change?
Next
From: Bruce Momjian
Date:
Subject: Re: update syntax