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!!!!