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