Re: Hierarchical queries a la Oracle. Patch.

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
>
>