| 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:29:53 |
| Message-ID: | Pine.LNX.4.33.0211282128070.319-100000@ns.terminal.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
it supports both versions: start before connect and vice versa.
regards,
---
.evgen
On Tue, 26 Nov 2002, 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).
>
> 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(at)redhat(dot)com
> 2323 Yonge Street, Suite #300
> Toronto, Ontario M4P 2C9
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Richards | 2002-11-28 17:36:47 | contrib/xml patch |
| Previous Message | Evgen Potemkin | 2002-11-28 17:24:12 | Hierarchical queries a la Oracle patch. for 7.3rc1. |