3 ms·
Still not really understanding - you can do all of that with plain UPDATEs (using join syntax if you want to "batch update many many rows at once with entirely
by hn_throwaway_99 3y ago
Still not really understanding - you can do all of that with plain UPDATEs (using join syntax if you want to "batch update many many rows at once with entirely different values.") I would be hella confused as a developer if I saw an INSERT ... ON CONFLICT statement where you specifically wanted to prevent any inserts.
- compumike 3y agoAh, by “join syntax” do you mean like this answer: https://stackoverflow.com/a/70803859 https://stackoverflow.com/a/70803859 ?
- hn_throwaway_99 3y agoUnnesting is a bit orthogonal, I'm basically saying any UPDATE statement that has a FROM clause in Postgres.