Re: loop with circular updates - Mailing list pgsql-general

From Kenneth Downs
Subject Re: loop with circular updates
Date
Msg-id 44C7813F.8040803@secdat.com
Whole thread Raw
In response to loop with circular updates  (Jessica M Salmon <jmsalmon@fs.fed.us>)
Responses Re: loop with circular updates  (Jessica M Salmon <jmsalmon@fs.fed.us>)
List pgsql-general
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 necessary/desirable to process
>subsequent records in the loop.
>
>
Can you tell us more about the app?  Sounds like an ERP allocation or
something like that.


Attachment

pgsql-general by date:

Previous
From: xyzyx
Date:
Subject: wrong timestamp
Next
From: Kenneth Downs
Date:
Subject: Re: Constraint on an aggregate? (need help writing trigger,