Обсуждение: collation.html natural sort

Поиск

Список

Период

Сортировка

От

jian he

Дата:

26 мая 2022 г., 17:30:09

https://www.postgresql.org/docs/15/collation.html

Numeric ordering, sorts sequences of digits by their numeric value, for example: A-21 < A-123 (also known as natural sort).

I guess maybe it should be 'A-21' < 'A-123' ?

I recommend David Deutsch's <<The Beginning of Infinity>>

Jian