Re: Recursive queries

On Tue, Jan 25, 2005 at 07:58:33PM +0100, Martijn van Oosterhout wrote:
> On Mon, Jan 24, 2005 at 05:27:46PM +0100, tmp wrote:
> > Are there any plans on implementing support for recursive queries in
> > postgresql in the near future? If so: When?
> >
> > I can see there has been some discussion on the subject in the
> > developer-group for quite some time ago, but aparently all thoughts of
> > recursive queries has been stalled. :-(
>
> What do you mean by resursive queries? A query can have a subquery
> which calls a function which executes another query. That counts as
> recursion in my book. What type of recursion are you thinking of?

The WITH clause in SQL2003 AFAIR (maybe earlier ones as well).

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Ellos andaban todos desnudos como su madre los parió, y también las mujeres,
aunque no vi más que una, harto moza, y todos los que yo vi eran todos
mancebos, que ninguno vi de edad de más de XXX años" (Cristóbal Colón)