SQLite Forum

Natural sort order
Login
*Apparently* PG doesn't do this natively, but there are a several solutions floating around:

- <https://github.com/Zeleo/pg_natural_sort_order> is a PG extension
- <https://stackoverflow.com/a/48809832> uses a PGSQL function

Those both use a function, so that the caller does `ORDER BY naturalsort(...)`. 

This post:

- <https://stackoverflow.com/questions/12965463/humanized-or-natural-number-sorting-of-mixed-word-and-number-strings>

Has several PG-only takes on the problem.