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.