comses.net
comses.net copied to clipboard
Create a Codebase Version ordering field
Lexicographic sort by version number doesn't work ("1" < "10" < "2"). Need an ordering field.
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..
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