I can't answer your question, but I'm sure it's possible to use if
statements instead of dynamically generated plsql code, which will make
your code actually more readable.
The if statements should be there anyway in your dynamic code generation
code... unless you get the code completely from outside as parameter,
which would be a bad security hole.
Why not replace the dynamic plsql code with if statements and possibly
dynamic SQL ?
Cheers,
Csaba.
On Mon, 2003-07-07 at 09:54, Natasa Bulatovic wrote:
> Hi dear All,
>
> I wander, is there a way to execute dynamic plpgsql code which is not restricted to sql command, but executes plpgsql
codeitself....
>
> For example... I would like to form dynamically a part of the code which contains ...
>
> "if-- end if... raise notice --- "
>
> I have been using such possibilities in Oracle, so pls. tell me if this possibility somehow is given in PlPgsql as
well?
>
>
> Cheers,
> Natasa