Re: recursive SQL functions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: recursive SQL functions
Date
Msg-id Pine.LNX.4.30.0202231406560.689-100000@peter.localdomain
Whole thread Raw
In response to Re: recursive SQL functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: recursive SQL functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane writes:

> I suspect it would not work to re-use a query plan tree at multiple
> recursion levels (someday, plan trees should be read-only during
> execution, but they ain't now).  As long as you are making a new
> plan tree for each recursive entry, it should work ...

ISTM that this is already what's happening.  Each level gets a new plan
tree.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: recursive SQL functions
Next
From: Tom Lane
Date:
Subject: Re: recursive SQL functions