Re: Dynamic plpgsql code

On Monday 07 Jul 2003 8:54 am, 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 code itself....
>
> 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?

Well - I wrote a plpgsql function that created a plpgsql function, but that's
about all you could do. There's no "eval()" type of call.

You can, of course execute dynamically formed SQL so that handle some of your
requirements.

--
Richard Huxton