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).
> Evgen Potemkin wrote:
>> + + 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
[START WITH expr] CONNECT BY PRIOR c_expr = c_expr
(we probably don't want to support operators other than '=')
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.
Red Hat - Toronto E-Mail: fnasser(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9
In response to
pgsql-patches by date
|Next:||From: Fernando Nasser||Date: 2002-11-26 23:46:29|
|Subject: Re: Hierarchical queries a la Oracle. Patch.|
|Previous:||From: Hannu Krosing||Date: 2002-11-26 22:21:48|
|Subject: Re: [HACKERS] Hirarchical queries a la Oracle. Patch.|