Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4GJ1fA29128 for ; Wed, 16 May 2001 15:01:41 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mail17b.wh.ocn.ne.jp (mail17b.wh.ocn.ne.jp [210.190.172.52]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4F8c4A74109 for ; Tue, 15 May 2001 04:38:04 -0400 (EDT) (envelope-from yamahi@isi-webnet.co.jp) Received: from www.isi-webnet.co.jp (210.190.149.216) by mail17b.wh.ocn.ne.jp (RS ver 1.0.58s) with SMTP id 03065862 for ; Tue, 15 May 2001 17:37:46 +0900 (JST) Message-ID: <000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp> From: =?iso-2022-jp?B?GyRCOzMkNSRzGyhC?= To: Subject: Give me a suggestion 'START WITH .. CONNECT BY'. Date: Tue, 15 May 2001 17:40:32 +0900 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C0DD66.23E53340" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Loop-Detect: 1 X-Archive-Number: 200105/171 X-Sequence-Number: 2988 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C0DD66.23E53340 Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: 7bit 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! Hirosi Yamaoka Co.ltd Integrated Systems Institute 701-0211 688-55 Higasiune, Okayama-city, Okayama-pref. Japan ------=_NextPart_000_0005_01C0DD66.23E53340 Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable
Hello!
I try to translate a database to PostgreSQL from ORACLE, but have a re= gret=20 over a function '... START WITH .. CONNECT BY ...'.
This function is descrived in a sql sentence for ORACLE, and I could n= ot=20 find in PostgreSQL.
For example
   SELECT LEVEL, COMP_ITM, COMP_NAME, COMP_AMT FRO= M=20 PSFILE
            STA= RT=20 WITH PRNT_ITM =3D 'A0010'
            CON= NECT=20 BY PRIOR COMP_ITM =3D PRNT_ITEM;
 
I  want to know an similar SQL description in PostgreSQL. Will yo= u=20 give me a suggestion?
           &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           =20 Thanks! 
=1B$B#H#i#r#o#s#i=1B(B =1B$B#Y#a#m#a#o#k#a=1B(B
Co.= ltd =1B$B#I#n#t#e#g#r#a#t#e#d=1B(B =1B$B#S#y#s#t#e#m#s=1B(B=20 =1B$B#I#n#s#t#i#t#u#t#e=1B(B
701-0211=1B$B!!=1B(B688-55 Higasiune, Okaya= ma-city, Okayama-pref.=20 Japan
------=_NextPart_000_0005_01C0DD66.23E53340--