Re: pass non-formated query to PL function

2021-04-02 Thread Joao Miguel Ferreira
Hi Pavel and Gianni, Thank you for the suggestions and documentation. That is exactly the kind of thing I was looking for. Cool, thx Joao On Fri, Apr 2, 2021 at 10:54 AM Gianni Ceccarelli wrote: > On 2021-04-02 Joao Miguel Ferreira > wrote: > > Is it possible, in PL/pgSQL, to pass an argumen

Re: pass non-formated query to PL function

2021-04-02 Thread Gianni Ceccarelli
On 2021-04-02 Joao Miguel Ferreira wrote: > Is it possible, in PL/pgSQL, to pass an argument to a function which > is actually a "query skeleton" that the method will "fill in the > blanks" and execute it or return it to the caller after ? you probably want to use the ``EXECUTE`` command: https:/

Re: pass non-formated query to PL function

2021-04-02 Thread Pavel Stehule
Hi pá 2. 4. 2021 v 11:35 odesílatel Joao Miguel Ferreira < joao.miguel.c.ferre...@gmail.com> napsal: > Hello all, > > Is it possible, in PL/pgSQL, to pass an argument to a function which is > actually a "query skeleton" that the method will "fill in the blanks" and > execute it or return it to th