Skip site navigation (1) Skip section navigation (2)

Re: Hierarchical queries a la Oracle. Patch.

From: Fernando Nasser <fnasser(at)redhat(dot)com>
To: Evgen Potemkin <evgent(at)ns(dot)terminal(dot)ru>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Hierarchical queries a la Oracle. Patch.
Date: 2002-11-26 18:44:19
Message-ID: 3DE3C103.4060502@redhat.com (view raw or flat)
Thread:
Lists: pgsql-patches
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


In response to

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-11-26 19:21:01
Subject: Re: release note fixes (7.3 & HEAD)
Previous:From: Peter EisentrautDate: 2002-11-26 18:42:03
Subject: Re: release note fixes (7.3 & HEAD)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group