Advertisement
Guest User

Untitled

a guest
Jun 12th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE FUNCTION opensips_cdrs_1_6() RETURNS TEXT
  2.     LANGUAGE plpgsql
  3.     AS $$
  4. DECLARE   bye_record  INTEGER DEFAULT 0;
  5.           v_callid varchar;
  6.           v_from_tag varchar;
  7.           v_to_tag varchar;
  8.           v_inv_time TIMESTAMP;
  9.           v_bye_time TIMESTAMP;
  10.           inv_cursor CURSOR FOR SELECT TIME, callid, from_tag, to_tag FROM acc WHERE METHOD='INVITE' AND cdr_id='0';
  11.           ROW RECORD;
  12. BEGIN
  13.   FOR ROW IN SELECT TIME, callid, from_tag, to_tag FROM acc WHERE METHOD='INVITE' AND cdr_id='
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement