pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (2+ messages)  latest in thread

Message-ID: <000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp>
Permalink:  ../000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp/
Also on:    postgresql.org/message-id/000c01c0dd1a$f1683340$6f40a8c0@isiwebnet.co.jp.isiwebnet.co.jp

 · 

reply

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