Newer
Older
update "TAP_SCHEMA".columns set arraysize = replace(arraysize, '*', '') where arraysize like '%*%';
update "TAP_SCHEMA".columns set arraysize = NULL where arraysize = '';
update "TAP_SCHEMA".columns set arraysize = replace(arraysize, '*', '') where arraysize like '%*%';
update "TAP_SCHEMA".columns set arraysize = NULL where arraysize = '';