eKo1

create or replace functionfind_international_tnc(IN digit_string, OUT international_tnc, OUT text)returns setof record as $$    select tnc.*, c.name    from international_tnc tnc, country c    where tnc.cc = c.code and $1 like tnc.cc || tnc.pattern || '%'    order by tnc.pattern desc$$ language sql;