On Sat, Jun 10, 2006 at 06:37:35PM -0400, Terry Lee Tucker wrote: > On Saturday 10 June 2006 06:31 pm, "Yavuz Kavus" <[EMAIL PROTECTED]> thus > communicated: > --> i am writing a recursive procedure in pl/pgsql. > --> i need to check whether a condition is true in any step of recursive > calls. --> > --> if i get a true response in one call, i wont make other recursive calls > --> anymore, because i get what i need. > --> if no one gives me a true response, then uppest procedure will return > false --> as a result. > --> > --> i think i may achieve this with a static variable(shared among all > calls). --> > --> is it possible? > --> > --> or another solution? > --> > --> thanks a lot for any help. > --> > I don't know of any static variable capability; however, I use various > utility > tables to accomplish this type of task. You can insert records into a table > like this while inside a transaction and the current process will be the only > process that can see it. When you are through with it, delete the record, all > within the same transaction, and your purpose will be served.
If you use a temp table for that, you can have it truncate on commit/rollback. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
