connectby documentation

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: Whole Thread | Raw Message | 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

Responses

Browse pgsql-sql by date

  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