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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, July 11, 2018, David Gauthier <davegauthierpg@xxxxxxxxx> 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.