Re: plpgsql cursors : dynamic or static?

Josh Berkus <josh@agliodbs.com> writes:
>> Are cursors in plpgsql dynamic or static?
>> 
>> 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?

The result definitely will be static in 7.3.  I'm not entirely sure
about prior releases: we used to manipulate the current-command counter
in a different way.
        regards, tom lane