Re: Natural sort order extension.

2020-02-12 Thread Dmitry Igrishin
On Wed, 12 Feb 2020, 19:55 Laurenz Albe, wrote: > On Wed, 2020-02-12 at 18:45 +0300, Dmitry Igrishin wrote: > > 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". > > > >

Re: Natural sort order extension.

2020-02-12 Thread Laurenz Albe
On Wed, 2020-02-12 at 18:45 +0300, Dmitry Igrishin wrote: > 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

Natural sort order extension.

2020-02-12 Thread Dmitry Igrishin
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