Follow

Today I learned: does not support ordering in updates.

That might not seem necessary at first, but in the very specific case that you have an index on a table and want to update the index field on many rows (e.g. to move items up in a queue) then you can easily run into contraint violations with large amounts of rows.

The fix - which I don't really like - is deferrable constraints. [0]

and some others support order by in updates 🤔

0: begriffs.com/posts/2017-08-27-

· · Web · 0 · 0 · 0
Sign in to participate in the conversation
Mastodon

Personal server of Hannes Leutloff aka yeldiR