| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Natasa Bulatovic <n(dot)bulatovic(at)zim(dot)mpg(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Dynamic plpgsql code |
| Date: | 2003-07-21 04:48:43 |
| Message-ID: | 200307210448.h6L4mhL29567@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Sure, use EXECUTE in PL/pgSQL.
---------------------------------------------------------------------------
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
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | u15074 | 2003-07-21 06:30:15 | Checkpoint question |
| Previous Message | Bruce Momjian | 2003-07-21 04:21:35 | Re: Rules and actions involving multiple rows |