Re: Recursive PLPGSQL function?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recursive PLPGSQL function?
Date: 2004-08-04 16:43:31
Message-ID: 2733.1091637811@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk> writes:
> I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2
> that given a tree node id (ictid) will return all the nodes below it in
> the tree, one row per node. When I try and execute the function I get
> the following error message:

You've got an infinite recursion there --- the function is calling
itself back with the original argument value.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message DeJuan Jackson 2004-08-04 16:56:24 Re: Recursive PLPGSQL function?
Previous Message Mark Cave-Ayland 2004-08-04 16:17:08 Recursive PLPGSQL function?