3 ms·
I'm forgiving on the authors point here. If you have JOINs and subqueries, you're just doing a SELECT to get data that can only be UPDATEd/INSERTed on a single
by wvenable 4y ago
I'm forgiving on the authors point here. If you have JOINs and subqueries, you're just doing a SELECT to get data that can only be UPDATEd/INSERTed on a single table. You can't do an INSERT across 5 tables in one statement.
- jamwt 4y agoArticle author here, yep, that was the intended point. Agree the wording was unclear, and there's a footnote now clarifying that. Thanks!
- wvenable 4y agoOne could argue that one statement vs. many statements isn't particularly important and as long as you have transactions.
- mkleczek 4y agoYou can in PostgreSQL and it is very useful: https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-MODIFYING https://www.postgresql.org/docs/current/queries-with.html#QU...