retrieve old value while executing an update statement

From: codadilupo <>
Date: Tue, 11 Mar 2008 10:06:07 +0100
Message-ID: <47d64b7f$0$21209$>

Is there a way to retrieve the old value of a column inside an UPDATE statement without executing a SELECT first?

Something like:

update x set name='my new name' returning old name into old_name ;


Thank you. Kind regards, C. Received on Tue Mar 11 2008 - 04:06:07 CDT

Original text of this message