create or replace function calls_fn_update_describes() returns void as 
$$
begin
    lock table phone_params_countgroups,
               phone_tarif_tarifs,
               phone_tarif_describegroups,
               phone_tarif_describecodes,
               phone_tarif_describezones
         in SHARE mode;
    update calls_describes
    set code_id=t.code_id,
        zone_id=t.zone_id,
        need_to_see=FALSE
    from (
        select call_id,
               describe[ 1 ] as code_id,
               describe[ 2 ] as zone_id
        from (
            select t.call_id, calls_fn_collect_describes(codes) as describe
            from (
                select cns.call_id,
                    calls_a_collect_describes_ar(
                        ARRAY[dc.id,
                        length(dgi.ierarchy),
                        length(dc.code),
                        cast(dc.cut as int4),
                        dz.id]
                    ) as codes
                from   calls_v_describe_need_to_see_work cns
                join phone_tarif_describegroups dgi
                    on  dgi.id=cns.describe_id
                join phone_tarif_describegroups dg
                    on  dg.ierarchy @> dgi.ierarchy
                join phone_tarif_describecodes dc
                    on  dc.code @> cns.called_ident
                    and dc.time_from <= cns.time_start
                    and dc.time_to   >  cns.time_start
                    and dc.group_id = dg.id
                join phone_tarif_describezones dz
                    on  dz.zone = dc.zone
                    and dz.group_id = dg.id
                order by length(dgi.ierarchy) asc,length(dc.code) asc
            ) t
            union all
            select NULL,NULL where FALSE;
        ) t
    ) t
    where calls_describes.call_id=t.call_id;
end;
$$
language plpgsql;
--Отвечает 
/*
ERROR:  mismatched parentheses
CONTEXT:  compile of PL/pgSQL function "calls_fn_update_describes" near line 8
*/