Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DO $do$
- DECLARE cmonth TEXT;
- DECLARE dmonth TEXT;
- BEGIN
- FOR i IN 1..15 LOOP
- cmonth = CONCAT('"credMonth' , i::text, '"');
- dmonth = CONCAT('"debMonth' , i::text, '"');
- EXECUTE
- format('SELECT
- "mainObj", "FY", "setOfBooks", $1, $2, $3 AS "fiscalMonth"
- FROM
- "wde_transaction_figures"
- WHERE
- "dataType" = ''(80)'' AND
- ($1 != ''0.00'' OR $2 != ''0.00'')')
- USING cmonth, dmonth, i;
- END LOOP;
- END
- $do$ LANGUAGE plpgsql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement