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