Скачать или смотреть How does alphanumeric sorting work in postgresql ?

https://ibmimedia.com/blog/3295/how-d...

Alphanumeric sorting is a way of sorting strings that contain both letters and numbers.

This sort of sorting arranges alphanumeric values in a specific order, which is done by a lexicographic sorting order, where the ASCII/Unicode character codes are taken into account.

In PostgreSQL, there are two ways to do alphanumeric sorting: Natural sorting and Custom sorting.

1. Natural sorting: This involves organizing alphanumeric values in an order that takes into account the numerical order present in the value. If we were to look at the values "A1", "A10", and "A2", they would be sorted as "A1", "A2", and "A10".

2. Custom Sorting: If natural sorting is not suitable for a given scenario, custom sorting can be used to define a particular order by utilizing the ORDER BY clause in an SQL query. This allows us to assign weights to different characters or character sets, so that the desired sorting order can be created.

Go to the web address provided above for the full Article.