Re: Recursive PLPGSQL function? - Mailing list pgsql-general

From Tom Lane
Subject Re: Recursive PLPGSQL function?
Date
Msg-id 2733.1091637811@sss.pgh.pa.us
Whole thread Raw
In response to Recursive PLPGSQL function?  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
List pgsql-general
"Mark Cave-Ayland" <m.cave-ayland@webbased.co.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

pgsql-general by date:

Previous
From: "Mark Cave-Ayland"
Date:
Subject: Recursive PLPGSQL function?
Next
From: DeJuan Jackson
Date:
Subject: Re: Recursive PLPGSQL function?