On 22 May 2017 at 09:06, Riaan Stander <rstander@exa.co.za> 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