update syntax

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: update syntax
Date: 2002-01-27 00:18:45
Message-ID: 20020127001845.26972.qmail@web12701.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-01-27 00:37:45 Re: update syntax
Previous Message postgresql 2002-01-27 00:03:06 interval and timestamp change?