Re: Recursive queries - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: Recursive queries
Date
Msg-id 20050125023448.GT67721@decibel.org
Whole thread Raw
In response to Re: Recursive queries  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-general
On Mon, Jan 24, 2005 at 06:30:52PM -0500, Christopher Browne wrote:
> Quoth tmp <skrald@amossen.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@decibel.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?"

pgsql-general by date:

Previous
From: elein@varlena.com (elein)
Date:
Subject: PostgreSQL General Bits Issue # 94
Next
From: "Jim C. Nasby"
Date:
Subject: Re: How are foreign key constraints built?