From: | Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru> |
---|---|
To: | Fernando Nasser <fnasser(at)redhat(dot)com> |
Cc: | <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: Hierarchical queries a la Oracle. Patch. |
Date: | 2002-11-28 17:37:31 |
Message-ID: | Pine.LNX.4.33.0211282134450.319-100000@ns.terminal.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
it's fixed in patch for PG 7.3
'+' comes from .diff, where you take it from :)
regards,
---
.evgen
On Tue, 26 Nov 2002, Fernando Nasser wrote:
> Fernando Nasser wrote:> The syntax below is wrong. Oracle has:
> >
> > [START WITH condition] CONNECT BY condition
> >
> > not the reverse as stated below. Maybe this was just a documentation
> > mistake (I haven't looked at the code).
> >> + + Syntax.
> >> + + SELECT ... FROM ... [ WHERE condition ] CONNECT BY c_expr PRIOR
> >> c_expr START WITH expr + [ HAVING condition [, ...]] [ LIMIT ... ] [
> >> OFFSET ... ]
> >> +
> >
>
> Furthermore, PRIOR is not a clause, but a unary operator that must be applied to
> one of the terms of the CONNECT BY expression.
>
> So, we would actually have:
>
> [START WITH expr] CONNECT BY c_expr = PRIOR c_expr
>
> And there is that '+' in there... what is it for?
>
>
> So I guess we would be implementing something that is not either the standard
> SQL nor the Oracle syntax.
>
>
>
> --
> Fernando Nasser
> Red Hat - Toronto E-Mail: fnasser(at)redhat(dot)com
> 2323 Yonge Street, Suite #300
> Toronto, Ontario M4P 2C9
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Nasser | 2002-11-28 19:06:27 | Re: Hierarchical queries a la Oracle. Patch. |
Previous Message | Michael Richards | 2002-11-28 17:36:47 | contrib/xml patch |