Postgres Pro
Downloads
Home   >   mailing lists

Give me a suggestion 'START WITH .. CONNECT BY'. - Mailing list pgsql-sql

From 山さん
Subject Give me a suggestion 'START WITH .. CONNECT BY'.
Date
Msg-id 000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp
Whole thread Raw
Responses Re: Give me a suggestion 'START WITH .. CONNECT BY'.  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Tree view
Hello!
I try to translate a database to PostgreSQL from ORACLE, but have a regret over a function '... START WITH .. CONNECT BY ...'.
This function is descrived in a sql sentence for ORACLE, and I could not find in PostgreSQL.
For example
   SELECT LEVEL, COMP_ITM, COMP_NAME, COMP_AMT FROM PSFILE
            START WITH PRNT_ITM = 'A0010'
            CONNECT BY PRIOR COMP_ITM = PRNT_ITEM;
 
I  want to know an similar SQL description in PostgreSQL. Will you give me a suggestion?
                                                              Thanks! 
Ｈｉｒｏｓｉ Ｙａｍａｏｋａ
Co.ltd Ｉｎｔｅｇｒａｔｅｄ Ｓｙｓｔｅｍｓ Ｉｎｓｔｉｔｕｔｅ
701-0211　688-55 Higasiune, Okayama-city, Okayama-pref. Japan

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)]
Next
From: "G. Anthony Reina"
Date:
Subject: "avg" function for arrays?