| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Girish Bajaj <gbajaj(at)tietronix(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: plpgsql execution |
| Date: | 2003-07-25 15:40:59 |
| Message-ID: | 20030725084030.U31713-100000@megazone.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, 25 Jul 2003, Girish Bajaj wrote:
> Is there any way I can run the following code in the query executer without
> creating a function for it?
Not that I know of.
>
> FOR i IN 1..100 LOOP
>
> PERFORM time_delay(1);
>
> insert into worklist(startid, endid, cellid, campaignid, status, claim,
> flastjob) values(1,2,3,4,5,\'mju\',CAST(1 as BIT));
>
> END LOOP;
>
>
>
> The language is PLPGSQL. And I really don't want to write a function to
> execute it. Can the query executer automatically execute it for me?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yogesh bhanu | 2003-07-25 15:47:32 | Update PG-7.3.2 and tru64 5.1a |
| Previous Message | Greg Spiegelberg | 2003-07-25 15:33:51 | Re: \connect ...ing since a dbserver to another |