WITH RECURSIVE ... simplified syntax? - Mailing list 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


pgsql-hackers by date:

Previous
From: Kris Jurka
Date:
Subject: Fixes for psql describeOneTableDetails
Next
From: Alvaro Herrera
Date:
Subject: Re: [WIP] plpgsql is not translate-aware