From: 山さん <yamahi@isi-webnet.co.jp>
To: pgsql-sql@postgresql.org
Subject: Give me a suggestion 'START WITH .. CONNECT BY'.
Date: Tue, 15 May 2001 17:40:32 +0900
Message-ID: <000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: yamahi@isi-webnet.co.jp
Subject: Re: Give me a suggestion 'START WITH .. CONNECT BY'.
In-Reply-To: <000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp>
References: <000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox