From: | "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com> |
---|---|
To: | "postgresql sql list" <pgsql-sql(at)postgresql(dot)org> |
Subject: | connectby documentation |
Date: | 2006-03-13 15:37:37 |
Message-ID: | 1E293D3FF63A3740B10AD5AAD88535D201C34616@UBIMAIL1.ubisoft.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I'm searching for an Oracle START WITH ... CONNECT BY PRIOR ...
equivalence. It seems that PostgreSQL (version >= 7.4) supports a
function connectby that provides similar feature. Unfortunately I don't
find any documentation on that function. Could you please give me a
link on such documentation?
Note: Just an example of the Oracle START WITH ... CONNECT BY PRIOR ...
behaviour.
4 |
| |
2 |
/ \ |
1 3 | Hierarchy dependency order
/ \ | |
5 | 6 |
|/ |
7 V
SELECT JobId, JobParentId
FROM JobDependency
START WITH JobParentId IN (
_Root_Datamarts_ )
CONNECT BY PRIOR JobId = JobParentId
JOBID JOBPARENTID
----- -----------
2 4
1 2
5 1
7 1
3 2
6 3
7 6
Regards,
--
Daniel
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-13 15:47:23 | Re: removing "not null" modifier |
Previous Message | Tom Lane | 2006-03-13 15:27:27 | Re: Permission to Select |