Re: recursive function needs static variable

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: recursive function needs static variable
Date: 2003-06-25 03:10:51
Message-ID: 1056510650.3449.83.camel@billy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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 ?

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

So, this is okay ?

> 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

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message wei wang 2003-06-25 03:15:37 set up windows client to connect via SSL
Previous Message Joe Conway 2003-06-25 02:57:00 Re: [NOVICE] connectby() minor bug in errormessage