Hi there,
I'd like to control the rows which are updated. I found useful the option
RETURNING in UPDATE syntaxt. Can I process the rows wich are returning there
?
I think to something like that:
SELECT *
FROM ( UPDATE "T" SET "C" = 1 WHERE "ID" > 100 RETURNING *
) x
TIA,
Sabin