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

Reply via email to