select concat(
    case when h.postalcode is not null then concat(h.postalcode,', ') end,
    coalesce(a.address,addrobj_address(h.aoguid)),
    case when housenum is not null then concat(', д. ',h.housenum) end,
    case when buildnum is not null then concat(', корп. ',h.buildnum) end,
    case when strucnum is not null then concat(', стр. ',h.strucnum) end
    ) as addr
  from houses h
  join fiasaddrobj a on a.aoguid=h.aoguid
  where h.houseguid=p_houseguid and h.enddate>=current_date 
  order by h.enddate desc   
  limit 1;

WITH RECURSIVE addr_tree AS
  (
    SELECT aoguid,parentguid,concat(ao.shortname,'. ',ao.formalname) as addr, 1 AS lev FROM fiasaddrobj ao WHERE ao.livestatus=1 and ao.aoguid=p_aoguid and actstatus=1 and livestatus=1 and currstatus=0 and enddate>=current_date
    UNION ALL
    SELECT ao.aoguid,ao.parentguid,concat(ao.shortname,'. ',ao.formalname) as addr, t.lev+1 AS lev FROM fiasaddrobj ao, tree t WHERE ao.aoguid = t.parentguid and actstatus=1 and livestatus=1 and currstatus=0 and enddate>=current_date
  )
select string_agg(addr,', '  order by lev desc) from addr_tree;