every single query in postrgresql runs as a transaction, on top of it,some are atomic, like when you use RETURNING statement. This isbecause postgresql doesn't actually have to select these rows asseparate query.