Natural sort order extension.

From: Dmitry Igrishin <dmitigr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Natural sort order extension.
Date: 2020-02-12 15:45:25
Message-ID: CAAfz9KPYp0MQ_30w1vKHBTWfQ=JZLxAH-ty4oZ2sgYe09c+d5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-02-12 16:39:27 Re: How to restore roles without changing postgres password
Previous Message Tom Lane 2020-02-12 15:15:59 Re: Avoiding out of date statistics / planner