Re: Hierarchical queries a la Oracle patch. for 7.3rc1.

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Fernando Nasser <fnasser(at)redhat(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Hierarchical queries a la Oracle patch. for 7.3rc1.
Date: 2002-12-05 22:38:11
Message-ID: 200212052238.gB5McBS17588@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches


That's all I needed to hear (and Tom's comment). Thanks.

I am sure you understand I need something concrete to tell the submitter
when I reject it. Thanks.

---------------------------------------------------------------------------

Fernando Nasser wrote:
> Bruce Momjian wrote:> This is a pretty sizable patch, and there was discussion
> about it.
>
> On which there were objections that were not addressed. I, for instance,
> complained about the addition of a syntax that is neither SQL not Oracle. And
> the last version of the patch still has it.
>
> Also, I felt that there was a consensus that we should implement the SQL99 (and
> DB2) recursive queries instead because:
> 1) It is the _standard_
> 2) The Oracle clause is less generic (less powerful) than the standard
> 3) One can add the Oracle weird clause as a syntactic sugar to a specific
> recursive query construct (as I have shown in one posting)
> 4) Adding the Oracle clause as a hack may prevent us to implement the real SQL thing
>
>
>
>
>
>
> --
> Fernando Nasser
> Red Hat - Toronto E-Mail: fnasser(at)redhat(dot)com
> 2323 Yonge Street, Suite #300
> Toronto, Ontario M4P 2C9
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-12-05 22:38:57 Re: Hierarchical queries a la Oracle patch. for 7.3rc1.
Previous Message Hannu Krosing 2002-12-05 21:27:46 Re: Hierarchical queries a la Oracle patch. for 7.3rc1.