Ludwig,
> Are cursors in plpgsql dynamic or static?
>
> For example :
>
> ... /* some code */
> FOR rec in SELECT f1,f2
> FROM table1 WHERE .... LOOP
>
> /* some codes that manipulate table1 */
> END LOOP;
Technically speaking, that is not a cursor, even though it serves the same
purpose.
I'm pretty sure it's static, but it would be easy to test ... why don't you
give it a try?
--
-Josh Berkus
Aglio Database Solutions
San Francisco