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