From ff2722639be03a9242d3adf43be62dbc473a2a70 Mon Sep 17 00:00:00 2001 From: Sebastian Harl Date: Sun, 4 Nov 2012 15:35:07 +0100 Subject: [PATCH] postrr.sql: Don't use 'EXECUTE' in PostRR_update(). This will, hopefully, improve performance a bit. --- src/postrr.sql.in | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) diff --git a/src/postrr.sql.in b/src/postrr.sql.in index 10aeb77..af96a92 100644 --- a/src/postrr.sql.in +++ b/src/postrr.sql.in @@ -361,12 +361,7 @@ DECLARE BEGIN FOR adef IN SELECT tbl, tscol, vcol FROM postrr.rrarchives WHERE postrr.rrarchives.rraname = $1 LOOP - EXECUTE 'SELECT PostRR_update(' - || quote_literal(adef.tbl) || ', ' - || quote_literal(adef.tscol) || ', ' - || quote_literal(adef.vcol) || ', ' - || quote_literal(ts) || ', ' - || quote_literal(value) || ')' + SELECT PostRR_update(adef.tbl, adef.tscol, adef.vcol, $2, $3) INTO new; RETURN NEXT new; END LOOP; -- 2.30.2