Hacker News new | ask | show | jobs
by Tostino 331 days ago
In Postgres they absolutely can. They are all just happening inside the same transaction scope unlike stored procedures.
1 comments
flysand7 328 days ago
Speaking 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
    )
link