Re: Hierarchical queries a la Oracle. Patch.

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

Fernando

Evgen Potemkin wrote:
> +
> + Syntax.
> +
> + SELECT ... FROM ... [ WHERE condition ] CONNECT BY c_expr PRIOR c_expr START WITH expr
> +   [ HAVING condition [, ...]] [ LIMIT ... ] [ OFFSET ... ]
> +



--
Fernando Nasser
Red Hat - Toronto                       E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9