On Saturday 10 June 2006 06:31 pm, "Yavuz Kavus" <yavuzkavus@xxxxxxxxx> 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. HTH...
