On Wed, Jul 11, 2018 at 2:44 PM, David Gauthier
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
On Wednesday, July 11, 2018, David Gauthier
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:
Hi:
I have a table listing tools and tool versions for a number of different
tool configurations. Something like this...
create table tv (tool text, tcfg1 test, tcfg2 text, tcfg3 text, highestver
text);
insert into tv (tool,tcfg1mtcfg2,tcfg3) values
('tool_a','1.0.5b','1.0.10','1.0.9');
I