How to ORDER BY typical software release versions like X.Y.Z?

29 votes

3 answers

20324 views

postgresql order-by sorting natural-sort

                          Given a "SoftwareReleases" table:

    | id | version |
    |  1 | 0.9     |
    |  2 | 1.0     |
    |  3 | 0.9.1   |
    |  4 | 1.1     |
    |  5 | 0.9.9   |
    |  6 | 0.9.10  |

How do I produce this output?

    | id | version |
    |  1 | 0.9     |
    |  3 | 0.9.1   |
    |  5 | 0.9.9   |
    |  6 | 0.9.10  |
    |  2 | 1.0     |
    |  4 | 1.1     |
                        

Asked by Chris Betti (487 rep)

Aug 18, 2014, 05:46 PM
Last activity: Jul 7, 2021, 02:42 PM

How to ORDER BY typical software release versions like X.Y.Z?

Related Questions