create table test1 (street varchar(200), building varchar(200));
insert into test1(street, building) values ('улица 1-я', '3');
insert into test1(street, building) values ('улица 2-я', '2-10 (четная сторона)');
insert into test1(street, building) values ('улица 3-я', '9-21 (нечетная сторона)');
insert into test1(street, building) values ('улица 4-я', '1-5 (четная + нечетная сторона)');
insert into test1(street, building) values ('улица 5-я', '9А-9В (адреса с буквами)');

with parsed as (
    select 
        street, 
        building, 
        type_, 
        case 
            when type_=4 then regexp_replace(building, '^([0-9]+)([А-Я])-[0-9]+([А-Я])$', '\1') 
            else null 
        end as basenum /* базовый номер дома*/,
        case type_ 
            when 0 then null 
            when 4 then regexp_replace(building, '^([0-9]+)([А-Я])-[0-9]+([А-Я])$', '\2') 
            else regexp_replace(building, '^([0-9]+)-([0-9]+)$', '\1') 
        end as lo_val /* нижняя граница диапазона */,
        case type_ 
            when 0 then null 
            when 4 then regexp_replace(building, '^([0-9]+)([А-Я])-[0-9]+([А-Я])$', '\3') 
            else regexp_replace(building, '^([0-9]+)-([0-9]+)$', '\2') 
        end as hi_val /* верхняя граница диапазона */
    from (
        select 
            street, 
            regexp_replace(building, '^(.*?)\s*\((.+)\)$', '\1') as building, 
            case regexp_replace(building, '^.*\((.+)\)$', '\1')
                when 'четная сторона' then 1
                when 'нечетная сторона' then 2
                when 'четная + нечетная сторона' then 3
                when 'адреса с буквами' then 4
                else 0
            end as type_ 
        from test1 
    ) t
)
select street, building from parsed where type_=0
union
select street, ''||generate_series(cast(lo_val as integer), cast(hi_val as integer), 2) from parsed where type_ in (1, 2)
union
select street, ''||generate_series(cast(lo_val as integer), cast(hi_val as integer)) from parsed where type_=3
union
select street, basenum||substr('АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЫЭЮЯ',x,1) from (
    select 
        street, 
        basenum, 
        generate_series(strpos('АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЫЭЮЯ', lo_val), strpos('АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЫЭЮЯ', hi_val)) x 
    from parsed 
    where 
        type_=4 
        and strpos('АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЫЭЮЯ', lo_val)>0 
        and strpos('АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЫЭЮЯ', hi_val)>strpos('АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЫЭЮЯ', lo_val)
) t