Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eA34Zfl68441 for ; Thu, 2 Nov 2000 23:35:41 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from donpac.ru (ns.donpac.ru [195.161.172.254]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA1E2hl56721 for ; Wed, 1 Nov 2000 09:02:43 -0500 (EST) (envelope-from naumov@r-style.donpac.ru) Received: from www.r-style.donpac.ru (rstyle-ATS52.donpac.ru [195.161.173.143]) by donpac.ru (8.9.1/8.9.1/cae1.1.0.4) with ESMTP id RAA10750 for ; Wed, 1 Nov 2000 17:02:16 GMT Received: from veles.r-style.donpac.ru (veles [192.168.1.22]) by www.r-style.donpac.ru with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id V026C5XB; Wed, 1 Nov 2000 18:00:44 +0300 Received: (from naumov@localhost) by veles.r-style.donpac.ru (8.9.3/8.9.3) id RAA04572 for pgsql-sql@postgresql.org; Wed, 1 Nov 2000 17:02:13 +0300 Date: Wed, 1 Nov 2000 17:02:12 +0300 From: "Sergei O . Naumov" To: pgsql-sql@postgresql.org Subject: Help! Storing trees in Postgres Message-ID: <20001101170212.A4550@veles.r-style.donpac.ru> Reply-To: naumov@r-style.donpac.ru Mime-Version: 1.0 Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: 8bit X-Mailer: Balsa 0.8.1 X-Archive-Number: 200011/19 X-Sequence-Number: 50 Hi! I just subscribed myself to this list and sent a message but I am not sure that it reached the list. So, I am asking one more time. :-) Is there any way to implement a query in Postgres that would be in some way analogues to Oracle's START WITH/CONNECT BY structure? I'd very much appreciate any suggestions. Thanks in advance, Sergei