Home > mailing lists

collation.html natural sort - Mailing list pgsql-docs

From	jian he
Subject	collation.html natural sort
Date	May 26, 2022 17:30:09
Msg-id	CACJufxHjYLQPB=SVRm-iF358Jv+SnP8aDzX+EwDiVR7t9-gxOA@mail.gmail.com Whole thread Raw
List	pgsql-docs

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

From: Bruce Momjian
Date: 25 May 2022, 02:57:26
Subject: Re: about pg14 new parameter in_hot_standby

From: Shay Rojansky
Date: 28 May 2022, 00:35:10
Subject: Incorrect and missing docs for range_intersect_agg