2013/10/1 Perry Smith <pedzsan@xxxxxxxxx>
It is possible to use RETURNING clause of the UPDATE statement and avoid SELECT.
On Oct 1, 2013, at 12:23 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
> Assuming you are not doing this in a function, you can. Do UPDATE, then SELECT to see your changes or not and then ROLLBACK.
Ah... yes. I forgot you can see the changes within the same transaction. Dohhh...
And yes, it is necessary to do this within a transaction and roll it back after.
--
Victor Y. Yegorov
Victor Y. Yegorov
