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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
