connectby documentation
От | Daniel Caune |
---|---|
Тема | connectby documentation |
Дата | |
Msg-id | 1E293D3FF63A3740B10AD5AAD88535D201C34616@UBIMAIL1.ubisoft.org обсуждение исходный текст |
Ответы |
Re: connectby documentation
|
Список | 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
В списке pgsql-sql по дате отправления: