Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. DO $do$
  2. DECLARE cmonth TEXT;
  3. DECLARE dmonth TEXT;
  4.  
  5. BEGIN
  6. FOR i IN 1..15 LOOP
  7.  
  8. cmonth = CONCAT('"credMonth' , i::text, '"');
  9. dmonth = CONCAT('"debMonth' , i::text, '"');
  10.  
  11. EXECUTE
  12. format('SELECT
  13. "mainObj", "FY", "setOfBooks", $1, $2, $3 AS "fiscalMonth"
  14. FROM
  15. "wde_transaction_figures"
  16. WHERE
  17. "dataType" = ''(80)'' AND
  18. ($1 != ''0.00'' OR $2 != ''0.00'')')
  19. USING cmonth, dmonth, i;
  20.  
  21. END LOOP;
  22. END
  23. $do$ LANGUAGE plpgsql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement