Re: recursive function needs static variable - Mailing list pgsql-novice

From Joe Conway
Subject Re: recursive function needs static variable
Date
Msg-id 3EF92687.3040704@joeconway.com
Whole thread Raw
In response to Re: recursive function needs static variable  (Nabil Sayegh <postgresql@e-trolley.de>)
Responses Re: recursive function needs static variable  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
Nabil Sayegh wrote:
> Am Mit, 2003-06-25 um 04.34 schrieb Joe Conway:
>
>>Nabil Sayegh wrote:
>
>>Each backend connection is a single threaded process, so there should be
>>no problem. But I don't think it needs to be static anyway (see below).
>
> Is this also true for several function calls in 1 query ?

Yes. Each call to connectby_text() will run to completion and return the
results as a tuplestore.

>>>I guess, that if I set the variable to 1 at each beginning of the
>>>function, it will conflict.
>
> So, this is okay ?

Should be fine.

>
>>Add the counter variable to build_tuplestore_recursively()'s arguments.
>>Initialize it in connectby(), and increment it every time
>>BuildTupleFromCStrings() is called.
>
> Already tried that, but due to the recursion the incrementation steps
> get undone each time the build_tuplestore_recursively returns :).
> => The serial is nomore UNIQUE

Not if you pass it by reference.

Joe


pgsql-novice by date:

Previous
From: wei wang
Date:
Subject: set up windows client to connect via SSL
Next
From: Kaarel
Date:
Subject: Re: Name limitation question