On 22 May 2017 at 09:06, Riaan Stander <rstander@xxxxxxxxx> wrote:
It sounds like you don't know about anonymous code blocks with DO
https://www.postgresql.org/docs/devel/static/sql-do.html
Yes I do know about that feature. My first implemented generated an
anonymous code block, but to my utter dismay once I tried actually doing
parameter binding from the application it did not work. This seems to be a
Postgres limitation actually stated in the documentation. The anonymous code
block is treated as a function body with no parameters.
Thanks for the suggestion though.
Perhaps we should look into parameterisable DO statements.
Now that I would second!!
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
