DO
	$$
DECLARE i INT ; rc RECORD ; rc2 TEXT ; _interval_start INT ; _interval_end INT ; _temp_array TEXT [];
BEGIN
	CREATE TABLE tmp_district_ch_1509 (
		ID int,
		address_id int,
		district_id int,
		building_pattern TEXT []
	) ; INSERT INTO tmp_district_ch_1509 (
		ID,
		address_id,
		district_id,
		building_pattern
	) SELECT
		ID,
		address_id,
		district_id,
		String_To_Array(mda.building_pattern, ',')
	FROM
		md_district_address mda ; 
    ALTER TABLE tmp_district_ch_1509 ADD buildings_list TEXT [];
    FOR rc IN ( SELECT	*	FROM tmp_district_ch_1509)
    LOOP
	BEGIN
		CASE
	WHEN array_lower(rc.building_pattern, 1) IS NULL THEN
		CONTINUE ;
	ELSE
		FOR rc2 IN (array_lower(rc.building_pattern , 1 ))..array_upper(rc.building_pattern, 1) LOOP
	BEGIN
		CASE
	WHEN rc2 LIKE ('%Ч(%') THEN
		_interval_start := CAST( (
			String_To_Array(
				regexp_replace(rc, 'Ч(|)', ''),
				'-'
			)
		) [ 1 ] as int) ; _interval_end := cast( (
			String_To_Array(
				regexp_replace(rc, 'Ч(|)', ''),
				'-'
			)
		) [ 2 ] as int); while (
			_interval_start < _interval_end
		) LOOP
	BEGIN
		_interval_start := _interval_start + 2 ; _temp_array := array_append(
			_temp_array,
			_interval_start
		) ;
	END ;
	END LOOP ;
	WHEN rc2 LIKE ('%Н()%') THEN
		_interval_start := cast( (
			String_To_Array(
				regexp_replace(rc, 'Н(|)', ''),
				'-'
			)
		) [ 1 ] as int) ; _interval_end := Cast((
			String_To_Array(
				regexp_replace(rc, 'Н(|)', ''),
				'-'
			)
		) [ 2 ] as int) ; while (
			_interval_start < _interval_end
		) loop
	BEGIN
		_interval_start := _interval_start + 2 ; _temp_array := array_append(
			_temp_array,
			_interval_start
		) ;
	END ;
	END loop ;
	WHEN rc2 LIKE ('%-%') THEN
		_interval_start := (String_To_Array(rc, '-')) [ 1 ] ; _interval_end := (String_To_Array(rc, '-')) [ 2 ] ; while (
			_interval_start < _interval_end
		) loop
	BEGIN
		_interval_start := _interval_start + 1 ; _temp_array := array_append(
			_temp_array,
			_interval_start
		) ;
	END ;
	END loop ;
            	
	WHEN UPPER (rc2) LIKE ('%ВСЕ%%') THEN
		_temp_array [ 1 ]:= 'ALL' ;
	ELSE
		_temp_array := array_append(_temp_array, rc2) ;
	END CASE ;
	END ;
	END LOOP ;

	END CASE ;
        END;
	END LOOP ; 
    
    SELECT
		*
	FROM
		_temp_array ; DROP TABLE tmp_district_ch_1509 ; END$$;

[Err] ERROR:  operator does not exist: integer ~~ unknown
LINE 1: SELECT rc2 LIKE ('%Ч(%')
                   ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
QUERY:  SELECT rc2 LIKE ('%Ч(%')
CONTEXT:  PL/pgSQL function inline_code_block line 31 at CASE