Re:Features I'd Like in PostgreSQL
by tshaddox on Sunday January 29, 2023 @01:59AM
(#34565638)
If you were going to enforce a maximum size so that you could sort on the client, I bet you could just use an integer and rewrite the entire sequence from 1 to N on every reorder operation. Unless you were expecting to have way more writes than reads, which is a little hard to imagine.
[ Parent
| on HN ]
> so that you could sort on the client
You could probably also sort in the database with a recursive cte or with PL/pgSQL.