From: | "Christian Kindler" <christian(dot)kindler(at)gmx(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | execute plpgsl like "normal" sql |
Date: | 2008-05-09 10:00:54 |
Message-ID: | 20080509100054.3400@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi
Is there a possibility to execute pl/pgsql syntax like normal sql simmilar to sql+ from oracle?
The question is: if I want to execute soemthing like this:
--File foo.sql:
begin
for id in select id from mytable loop
update myothertable set payed = true where fk_id = id;
end loop;
end;
Do I have to create a procedure or can I simply run the above statement via
psql -D foo < foo.sql
Reason is, that I create pq/psql procedures (more complex than this example) at runtime in my client app and do not want to store the procedures permanent in my database schema. I would like to avoid create function / drop function statements.
Thanks
Chris
--
GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/?mc=sv_ext_mf(at)gmx
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Kindler | 2008-05-09 15:00:34 | Re: execute plpgsl like "normal" sql |
Previous Message | Tom Lane | 2008-05-08 14:54:21 | Re: Index to enforce non-overlapping ranges? |