Re: [SQL] execute plpgsl like "normal" sql

2008-05-09 Thread Christian Kindler
Thanks! Chris Original-Nachricht > Datum: Fri, 9 May 2008 23:14:44 +1000 > Von: imad <[EMAIL PROTECTED]> > An: "Christian Kindler" <[EMAIL PROTECTED]> > Betreff: Re: [SQL] execute plpgsl like "normal" sql > Anonymous blocks are not supported in PostgreSQL. > -- GMX startet Sh

[SQL] execute plpgsl like "normal" sql

2008-05-09 Thread Christian Kindler
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