Untitled

create type  namenumber as (nm text, number int);
create function getlocalextn(text) returns setof namenumber as $$ select substring(callerid from '"(.*)" <\\d+>'), CAST(substring(callerid from '<(\\d+)>') as int) from sip_conf where accountcode like '$1'; $$ language 'sql';