In article <[EMAIL PROTECTED]>,
Yavuz Kavus <[EMAIL PROTECTED]> wrote:
% i am writing a recursive procedure in pl/pgsql.
% i need to check whether a condition is true in any step of recursive calls.
[...]
% i think i may achieve this with a static variable(shared among all calls).
I'm not sure a static variable is the right way to achieve this, but
you could use a custom_variable_class for this. Add this to your
postgresql.conf:
custom_variable_classes='global'
Then you can set and show variables prefixed by global.:
set global.success = 'true';
--
Patrick TJ McPhee
North York Canada
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
