Re: Dynamic plpgsql code - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Dynamic plpgsql code
Date
Msg-id 1057825162.1103.55.camel@coppola.ecircle.de
Whole thread Raw
In response to Dynamic plpgsql code  ("Natasa Bulatovic" <n.bulatovic@zim.mpg.de>)
List 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
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



pgsql-general by date:

Previous
From: icaplovic@gamo.sk
Date:
Subject: PostgreSQL, Cygwin - setting locales
Next
From: Richard Huxton
Date:
Subject: Re: Dynamic plpgsql code