|
Is there any way I can run the following code in the query executer without creating a function for it?
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?
Thanks, Girish
|
- Re: [ADMIN] plpgsql execution Girish Bajaj
- Re: [ADMIN] plpgsql execution Stephan Szabo
