Skip site navigation (1) Skip section navigation (2)

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

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
Subject: Re: FOR-IN-EXECUTE: FOR does not replanned on each entry to the FOR loop
Date: 2008-03-28 15:43:59
Message-ID: 47ED123F.80404@timbira.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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/

In response to

Responses

pgsql-bugs by date

Next:From: Euler Taveira de OliveiraDate: 2008-03-28 16:43:25
Subject: Re: Redundant explicit field name/types description while select from function with return type of record
Previous:From: Bruce MomjianDate: 2008-03-28 15:22:46
Subject: Re: [PATCHES] Incomplete docs for restore_command for hotstandby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group