Sure they can. See example here: https://www.postgresql.org/docs/current/plpgsql-transactions...