Re: plpgsql cursors : dynamic or static?

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 BerkusAglio Database SolutionsSan Francisco