Natural sort order extension. - Mailing list pgsql-general

From Dmitry Igrishin
Subject Natural sort order extension.
Date
Msg-id CAAfz9KPYp0MQ_30w1vKHBTWfQ=JZLxAH-ty4oZ2sgYe09c+d5g@mail.gmail.com
Whole thread Raw
Responses Re: Natural sort order extension.  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hi,

I've implemented a PostgreSQL extension for natural sort order. I.e.
strings like "z20", "z0004", "z11", "z2" sorted in ascending order as
"z2", "z0004", "z11", "z20".

Currently it implements the type textnso which is binary-coercible
to/from the text type. It's possible to declare table columns of type
textnso and create indexes on them.

Details are here https://github.com/dmitigr/pgnso

Any feedback are welcome!

Thanks.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Avoiding out of date statistics / planner
Next
From: Adrian Klaver
Date:
Subject: Re: How to restore roles without changing postgres password