how to maintain the order of a list in postgres

Question

how to maintain the order of a list in postgres

Closed this issue 5 years ago · 2 comments

Kelbie commented 5 years ago

with the resume builder, I need to select items in a fixed arbitrary order

Answer 1 · 2020-01-09T13:49:13.000Z

thread on user-defined order in SQL https://news.ycombinator.com/item?id=16635440

approach 3 looks the best but an alternative could be to simply store the order in an array-string

Answer 2 · 2020-02-07T23:25:55.000Z

closing this for now because I found a solution that involves storing the data as JSON which is not as efficient but works with no underlying complexity and also makes it very flexible.