Project

General

Profile

Download (637 Bytes)

Gaps #86764 » _renamedisplay_name_.sql

Mehdi Mehdi, 16/03/2026 06:48 PM

 
select
display_name ,
uom.*
from
public.unit_of_measure as uom
where
-- display_name like '%X%'
-- and
uom.identifier_code in (
'5xd',
'tid',
'bid'
);

update public.unit_of_measure set display_name = '5 times Daily' where identifier_code = '5xd'; commit ;
update public.unit_of_measure set display_name = '3 times Daily' where identifier_code = 'tid'; commit ;
update public.unit_of_measure set display_name = '2 times Daily' where identifier_code = 'bid'; commit ;

select
display_name ,
uom.*
from
public.unit_of_measure as uom
where
-- display_name like '%X%'
-- and
uom.identifier_code in (
'5xd',
'tid',
'bid'
);


(3-3/9)