recursive function needs static variable

Поиск
Список
Период
Сортировка
От Nabil Sayegh
Тема recursive function needs static variable
Дата
Msg-id 1056506107.3449.61.camel@billy
обсуждение исходный текст
Ответы Re: recursive function needs static variable  (Joe Conway <mail@joeconway.com>)
Список pgsql-novice
Hi all,

I just changed connectby() to order siblings and return an additional
serial column.

Everything is working fine so far, but I think there could be a problem
due to the static definition of the serial variable.

I need the variable to be static, because the function itself is
recursive.

What will happen if 2 processes concurrently use the function ? will
they conflict ?

I guess, that if I set the variable to 1 at each beginning of the
function, it will conflict.

If I do _not_ reset the serial at each function call, that would lead to
an overflow sooner or later.

Any idea ?

--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


В списке pgsql-novice по дате отправления:

Предыдущее
От: Nabil Sayegh
Дата:
Сообщение: connectby() minor bug in errormessage
Следующее
От: Joe Conway
Дата:
Сообщение: Re: recursive function needs static variable