| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| 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 21:27:46 |
| Message-ID: | 1039123665.2011.7.camel@rh72.home.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Bruce Momjian kirjutas R, 06.12.2002 kell 00:36:
> This is a pretty sizable patch, and there was discussion about it. Tom,
> are you saying you will apply it with different syntax, or that you will
> do another implementation.
>
> I need feedback from another person before I can just reject this.
I agree with Tom, that oracle's syntax is is both limited and horrible.
OTOH, if the internal implementation is ok, and the syntax does not
clash with possible future standard SQL syntax, I'd say it would be ok
to implement.
OTOOH, the full SQL99 hierarchical queries are much more powerful and
may require more (and possibly different) internal changes than the
"oracle" way of doing it.
The question is basically - do we want to tie ourselves toforever
supporting Oracle syntax here - for example we don't do outer joins the
Oracle way using =(+).
--
Hannu Krosing <hannu(at)tm(dot)ee>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-12-05 22:38:11 | Re: Hierarchical queries a la Oracle patch. for 7.3rc1. |
| Previous Message | Nicolai Tufar | 2002-12-05 21:01:22 | Re: Patch to make Turks happy. |