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. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
