Re: Recursive call indicator/counter

From: "Mark Wilson" <mark(at)mediasculpt(dot)com>
To: "Hadley Willan" <hadley(dot)willan(at)deeper(dot)co(dot)nz>, "Postgresql General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recursive call indicator/counter
Date: 2002-11-08 03:36:03
Message-ID: 05f701c286d7$fa2f4e10$3301a8c0@merl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You could add a 'depth' parameter, and when you call it again, pass in depth
+ 1.

----- Original Message -----
From: "Hadley Willan" <hadley(dot)willan(at)deeper(dot)co(dot)nz>
To: "Postgresql General" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, November 08, 2002 3:38 PM
Subject: [GENERAL] Recursive call indicator/counter

> Gudday' all.
>
> In plpgsql, I've written a function that can call itself if
> necessary and thus recurse down to the bottom of a tree, operate on
> bottom node, then as it comes out, operate on each node, until
> eventually it gets to the top again.
>
> However, is there any system variable that I can check to see if this
> function has just been called for the first time or if this is the nTH
> call from itself?
>
> Thanks.
> --
> Hadley Willan > Systems Development > Deeper Design Limited.
> hadley(at)deeper(dot)co(dot)nz > www.deeperdesign.com > +64 (21) 28 41 463
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emmanuel Gravel 2002-11-08 04:16:24 Permissions on functions
Previous Message Jeff Davis 2002-11-08 02:57:32 Re: postgres/perl problem in 7.3b5