3 ms·
It just shows the command. No talk about query plan performance or advantages over multiple updates and or deletes (which should be obvious I guess since this i
by gigatexal 5y ago
It just shows the command. No talk about query plan performance or advantages over multiple updates and or deletes (which should be obvious I guess since this is one statement vs two or more). Otherwise it’s a pretty lackluster blog post.
- iknownothow 5y agoI'm not denying the importance of performance and query planning here, but merging two statements into one is what I as a (specific kind of) data engineer care about more. Letting postgres take care of consistency while keeping the SQL readable is just pure value addition.