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.