WITH RECURSIVE ... simplified syntax?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: WITH RECURSIVE ... simplified syntax?
Date: 2008-10-08 23:11:45
Message-ID: 200810081611.46243.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

All,

I was discussing WITH RECURSIVE the other day, and realized that one thing
which we're not getting with this patch is a simplest-case simple syntax
which 75% of users are looking for. You know, the ones with simple
proximity trees who just want to find all children of one parent.

Would it be a worth it for us to implement a non-standard simple syntax
sugar on top of WITH RECURSIVE? Or, at least, something like
CONNECT_BY()?

--
--Josh

Josh Berkus
PostgreSQL
San Francisco

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-08 23:21:23 Re: [WIP] plpgsql is not translate-aware
Previous Message Alvaro Herrera 2008-10-08 23:07:58 Re: [WIP] plpgsql is not translate-aware