On Wed, Jul 11, 2018 at 2:44 PM, David Gauthier
<[hidden email]> wrote:
> I want to load the 'highestver' column with the highest version of tcfg1-3.
> 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 ?
If you're using v10 with ICU, then you can create a custom ICU
collation for this, with "natural" sort order. Something like this