Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2J975613743 for ; Mon, 19 Mar 2001 04:07:07 -0500 (EST) (envelope-from zakkr@zf.jcu.cz) Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.9.3/8.9.3/Debian 8.9.3-21) id KAA28446; Mon, 19 Mar 2001 10:06:54 +0100 Date: Mon, 19 Mar 2001 10:06:54 +0100 From: Karel Zak To: Grant Furick Cc: pgsql-sql@postgresql.org Subject: Re: hierarchical order equivalent Message-ID: <20010319100653.A26000@ara.zf.jcu.cz> References: <993hvg$j7v$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i In-Reply-To: <993hvg$j7v$1@news.tht.net>; from furick1@attglobal.net on Sun, Mar 18, 2001 at 06:56:17PM -0500 X-Archive-Number: 200103/351 X-Sequence-Number: 2015 On Sun, Mar 18, 2001 at 06:56:17PM -0500, Grant Furick wrote: > Is there an equivalent way to do this Oracle query in Postgres? > > Select category_id, parent_category_id, category_name > FROM Category > START WITH category_id = 6 > CONNECT BY PRIOR category_id = parent_category_id > Order by category_name > The PostgreSQL hasn't implemented Oracle's "walk tree" feature (yet??? -- speculate about it anyone?). If I good remember some discussion about hierarchy system in tables was before now, see archives at postgresql.org. Karel -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz