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

Reply via email to