Received: from dora.ins.at (dora.ins.at [194.152.96.75]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0UAwYq06641 for ; Tue, 30 Jan 2001 05:58:34 -0500 (EST) (envelope-from clemens.schmuck@ins.at) Received: from mypc.ins.at (adsl-125078.customers.ins.at [194.152.125.78]) by dora.ins.at (8.9.3/8.9.3) with ESMTP id LAA17388 for ; Tue, 30 Jan 2001 11:58:31 +0100 Message-Id: <5.0.0.25.2.20010130115636.00ad1e18@mailhost.ins.at> X-Sender: a0324001@mailhost.ins.at X-Mailer: QUALCOMM Windows Eudora Version 5.0 Date: Tue, 30 Jan 2001 11:59:53 +0100 To: pgsql-sql@postgresql.org From: clemens schmuck Subject: Hierarchical Queries Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200101/452 X-Sequence-Number: 1128 hi there, in the database i'm currently trying to implement i make heavy use of self joins and therefore i do often need to make hierarchical queries. oracle offers the connect by clause to do this. how can i do this with, postgresql? clemens