comses.net icon indicating copy to clipboard operation
comses.net copied to clipboard

Create a Codebase Version ordering field

Open cpritcha opened this issue 8 years ago • 2 comments

Lexicographic sort by version number doesn't work ("1" < "10" < "2"). Need an ordering field.

cpritcha avatar Dec 07 '17 21:12 cpritcha

Your suggestion to convert the version field from a string into a postgres array field for natural sort ordering seems like a reasonable choice if we can implement it quickly and it works as expected..

alee avatar Dec 18 '17 21:12 alee

Other options:

https://pgxn.org/dist/semver/doc/semver.html

https://dba.stackexchange.com/questions/74283/how-to-order-by-typical-software-release-versions-like-x-y-z

alee avatar Mar 12 '18 22:03 alee