From: | Terry Lee Tucker <terry(at)esc1(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: are there static variables in pgsql? |
Date: | 2006-06-10 22:37:35 |
Message-ID: | 200606101837.35415.terry@esc1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Saturday 10 June 2006 06:31 pm, "Yavuz Kavus" <yavuzkavus(at)gmail(dot)com> 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...
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-06-11 02:12:15 | Re: [GENERAL] TOAST not working |
Previous Message | Yavuz Kavus | 2006-06-10 22:31:36 | are there static variables in pgsql? |