Untitled

select distinct tariff_type from schedule_of_charges;

select count(distinct tariff_type) from schedule_of_charges;

select distinct tariff_type from schedule_of_charges where 'agreed' ~ lower(tariff_type);

select distinct tariff_type from schedule_of_charges where 'open' ~ lower(tariff_type);

select distinct tariff_type from schedule_of_charges where 'open' ~ lower(tariff_type) and length(tariff_type) > 3;

select distinct tariff_type from schedule_of_charges where 'agreed' ~ lower(tariff_type) and length(tariff_type) > 5;


begin;
update schedule_of_charges set tariff_type = 'open' where 'open' ~ lower(tariff_type) and length(tariff_type) > 3;
end;



begin;
update schedule_of_charges set tariff_type = 'agreed' where 'agreed' ~ lower(tariff_type) and length(tariff_type) > 5;
end;


select distinct tariff_type where 'agreed' ~ lower(s3url);

select distinct s3url from schedule_of_charges where 'agreed' ~ lower(s3url);

select distinct tariff_type from schedule_of_charges where 'agreed' ~ lower("s3url");

select distinct tariff_type from schedule_of_charges where 'agreed' ~ lower(schedule_of_charges.s3url);

select distinct tariff_type, s3url as filen  from schedule_of_charges where 'agreed' ~ lower(filen);

select distinct tariff_type, s3url as filen  from schedule_of_charges s where 'agreed' ~ lower(s.filen);

select distinct tariff_type, s3url  from schedule_of_charges s where 'agreed' ~ lower(s.s3url);


select distinct tariff_type  from schedule_of_charges where lower(s.s3url) ~ 'agreed';

select distinct tariff_type from schedule_of_charges where lower(s3url) ~ 'agreed';

select distinct tariff_type from schedule_of_charges where lower(tariff_type) ~ 'agreed' and length(tariff_type) > 5;

begin;
update schedule_of_charges set tariff_type = 'open' where lower(tariff_type) ~ 'open' and length(tariff_type) > 3;
end;

begin;
update schedule_of_charges set tariff_type = 'agreed' where lower(tariff_type) ~ 'agreed' and length(tariff_type) > 5;
end;

begin;
update schedule_of_charges set tariff_type = 'agreed' where lower(s3url) ~ 'agreed';
end;

begin;
update schedule_of_charges set tariff_type = 'open' where tariff_type not in ('agreed', 'open');
end;