Advertisement
Guest User

call function in loop

a guest
Jul 24th, 2019
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.50 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION get_all_ancestors()
  2. RETURNS TABLE (
  3.     c_id BIGINT,
  4.     p_id BIGINT,
  5.     p_type VARCHAR,
  6.     pd_type VARCHAR,
  7.     d_type VARCHAR,
  8.     d_value VARCHAR
  9. ) AS
  10. $BODY$
  11. DECLARE
  12.     r product_partition%ROWTYPE;
  13. BEGIN
  14.     FOR r IN
  15.         SELECT * FROM product_partition WHERE partition_type = 'Unit'
  16.     LOOP
  17.         RETURN NEXT
  18.             SELECT * product_partition_ancestors_fn(r.criterion_id, r.adgroup_id);
  19.     END LOOP;
  20.     RETURN;
  21. END
  22. $BODY$
  23. LANGUAGE plpgsql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement