create or replace function
find_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;