From: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
---|---|
To: | Natasa Bulatovic <n(dot)bulatovic(at)zim(dot)mpg(dot)de> |
Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Dynamic plpgsql code |
Date: | 2003-07-10 08:19:21 |
Message-ID: | 1057825162.1103.55.camel@coppola.ecircle.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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?
>
>
> Cheers,
> Natasa
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2003-07-10 08:23:54 | Re: IIRC + intervals + and other things |
Previous Message | Frank Millman | 2003-07-10 08:07:04 | This works in 7.2.1, not in 7.3.2 |