Обсуждение: CONNECT BY and WITH ...

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.
   best regards,
      hans

-- 
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql-support.de, www.postgresql-support.com

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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

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