3 ms·
In Postgres they absolutely can. They are all just happening inside the same transaction scope unlike stored procedures.
by Tostino 1y ago
In Postgres they absolutely can. They are all just happening inside the same transaction scope unlike stored procedures.
- flysand7 1y agoSpeaking of postgres, you don't even need a function, you can just use RETURNING clause of a modifying query to provide data source for the select: select * from ( delete from users returning id )