Request a Demo
Home   >   mailing lists

Re: sorting/comparing column values in non-alphanumeric sorting ways ? - Mailing list pgsql-general

From David G. Johnston
Subject Re: sorting/comparing column values in non-alphanumeric sorting ways ?
Date
Msg-id CAKFQuwaL5E_jjSHaEmJwUKRw7JYB=6C1Ow45kyio5f-LQn9+Lg@mail.gmail.com
Whole thread Raw
In response to sorting/comparing column values in non-alphanumeric sorting ways ?  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
Tree view
On Wednesday, July 11, 2018, David Gauthier <davegauthierpg@gmail.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:


David J.

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: sorting/comparing column values in non-alphanumeric sorting ways ?
Next
From: Peter Geoghegan
Date:
Subject: Re: sorting/comparing column values in non-alphanumeric sorting ways ?