[SQL] how to sort a column which contains Semantic Version in Postgres

Is there a way to efficiently store https://semver.org version string in Postgres and then do a latest query . e.g. Say column has values 1.1.0, 1.0.0, 1.2.0, 1.0.1-rc.1+B001 . I would like to sort and get the latest version number (1.2.0) ideally an optimized and performant query as it will be queried frequently.

Note: I would like to sort on a single column and get latest not compare 2 different columns. Also would like it to be full semver compliant.

Continue reading...