Re: FOR-IN-EXECUTE: FOR does not replanned on each entry to the FOR loop

Sorry, docs have confusing me.
I think 'each entry' means each iterations of loop. So maybe it is need to
fix doc. to describe for-in-execute more clearly

thx
----- Original Message -----
From: "Euler Taveira de Oliveira" <euler(at)timbira(dot)com>
To: <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Friday, March 28, 2008 5:43 PM
Subject: Re: [BUGS] FOR-IN-EXECUTE: FOR does not replanned on each entry to
the FOR loop

> Eugen(dot)Konkov(at)aldec(dot)com wrote:
>
>> FOR and WHILE results differ
>> WHILE returns two rows
>> but FOR returns only one.
>> and it seems that FOR does not replanned on each entry to the FOR loop
>> While docs says:
>> 38.6.4. Looping Through Query Results
>> ....
>> This is like the previous form, except that the source query is specified
>> as a string expression, which is evaluated and replanned on each entry to
>> the FOR loop
>>
> You are confusing things. The statement above talks about FOR rec IN
> EXECUTE query_string LOOP ... END LOOP. There is no WHILE.
> When you're using WHILE, the EXECUTE is actually evaluated inside the loop
> and not in the loop condition (that's why you're seeing another
> iteration).
>
>
> --
> Euler Taveira de Oliveira
> http://www.timbira.com/