AM cc
pgsql-general@postgresql.org
Subject
Re: [GENERAL] loop with circular
Jessica M Salmon <[EMAIL PROTECTED]> writes:
> -is it true that when looping over query results in a plpgsql
> for..in..execute loop, several records are stored in memory at one time?
Yes, but that's got nothing to do with your issue.
> -if I then update one of the records currently i
Subject
Re: [GENERAL] loop with circular
Jessica M Salmon wrote:
Hi All.
I'm writing a plpgsql function that creates a table and loops over the
items in that table, using a FOR ... IN EXECUTE ... loop. The thing is, on
each iteration I update the table over which I am looping. Sometimes, the
result of this update makes it no longer ne
