|
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 |
