Re: CONNECT BY and WITH ...

On Tue, Jul 08, 2008 at 07:28:36AM +0200, Hans-Juergen Schoenig wrote:
> good morning everybody,
>
> i know that this is really a hot potato on the mailing list but i
> think it is useful to discuss this issue. in the past few months
> we have been working with a customer to improve evgen's CONNECT BY
> patch. as we have a nice and promising WITH RECURSIVE patch the
> original CONNECT BY codes are pretty obsolete.
>
> however, in the past view weeks I have been asked more than once if
> it is possible to use the current with patch and add the parser
> support for CONNECT BY to it. so, people had the choice whether to
> go with CONNECT BY syntax (to be Oracle compliant, which is
> important) or ANSI SQL compliant (which is important as well).
>
> how are the feelings towards an improvement like that? i would ease
> the pain of many people for sure.

This has been discussed to death several times. We're only going to
do the WITH RECURSIVE (i.e. the SQL standard) tree handling.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate