Re: Recursive queries

On Mon, Jan 24, 2005 at 06:30:52PM -0500, Christopher Browne wrote:
> Quoth tmp <skrald(at)amossen(dot)dk>:
> > 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. :-(
>
> Other things have headed higher in terms of urgency.
>
> If someone volunteers to work on it, or if someone sponsors someone to
> work on it, that would doubtless increase its priority for 8.1 or
> such.
>
> I'd love to see it; the syntax provides ways to make complex queries a
> lot cleaner even if you're not recursing.

Depending on what you're doing you could also use contrib/ltree instead
of a recursive query.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"