Re: sorting/comparing column values in non-alphanumeric sorting ways ?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: David Gauthier <davegauthierpg(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: sorting/comparing column values in non-alphanumeric sorting ways ?
Date: 2018-07-11 21:50:21
Message-ID: CAKFQuwaL5E_jjSHaEmJwUKRw7JYB=6C1Ow45kyio5f-LQn9+Lg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, July 11, 2018, David Gauthier <davegauthierpg(at)gmail(dot)com>
wrote:

>
> This won't work...
> update tv set greatest = greatest(tcfg1,tcfg2,tcfg3)
> ...because it thinks 1.0.9 is greater than 1.0.10
>
> Is there a way to get this to work right ?
>
>
Haven't used it personally but this seems promising:

https://pgxn.org/dist/semver/doc/semver.html

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Geoghegan 2018-07-11 22:06:27 Re: sorting/comparing column values in non-alphanumeric sorting ways ?
Previous Message David Gauthier 2018-07-11 21:44:01 sorting/comparing column values in non-alphanumeric sorting ways ?