Hi Everyone, I want to thank everyone for their help / suggestions... I really appreciate it.
Though I think I have found a winner.
craig=# update x set val = foundrow.val from ( select val from x where id = 2 ) as foundrow where id = 1 ;UPDATE 1
Very elegant, very clean... Very nice! Thanks!!!! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql