Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. {"type":"monitoring","log":[
  2. ["2016-10-12T20:33:21","0.00","0.00","0.00","0.00","0.0","24.00","1.83","-0.00","1","1","-100.00"],
  3. ["2016-10-12T20:33:23","0.00","0.00","0.00","0.00","0.0","24.00","1.52","-0.61","1","1","-100.00"]]}
  4.  
  5. IF(NOT b_first_line) THEN
  6. s_insert_query_values = right(s_insert_query_values, -1); --remove te leading comma
  7.  
  8. EXECUTE format('INSERT INTO log_rlda
  9. (record_node_id, log_line, log_value, timestamp, record_log_id)
  10. VALUES %s;', s_insert_query_values);
  11.  
  12. s_insert_query_values = '';
  13. i_num_lines_buffered = 0;
  14. END IF;
  15. END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement