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