Comment by Tostino

In Postgres they absolutely can. They are all just happening inside the same transaction scope unlike stored procedures.