Re: WITH RECURSIVE ... simplified syntax? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: WITH RECURSIVE ... simplified syntax?
Date
Msg-id 162867790810082024g4aaa0a2cidfdddea64dc387f5@mail.gmail.com
Whole thread Raw
In response to WITH RECURSIVE ... simplified syntax?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Hello

2008/10/9 Josh Berkus <josh@agliodbs.com>:
> 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.
>

I thing so it's bad understanding of new syntax. It's really power and
easy, but it minimally needs look to manual. I am against to add some
non standard syntax, when we have standard.

regards
Pavel Stehule

p.s. CONNECT by should help to people with migration of older
application from DB2 or Oracle

> 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
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [WIP] plpgsql is not translate-aware
Next
From: Tom Lane
Date:
Subject: Re: [WIP] plpgsql is not translate-aware