Re: Recursive queries - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Recursive queries
Date
Msg-id 20050125193631.GA15811@dcc.uchile.cl
Whole thread Raw
In response to Re: Recursive queries  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
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[@]dcc.uchile.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)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recursive queries
Next
From: alejandro fernandez
Date:
Subject: Restore de Base de datos