Re: hierarchical order equivalent

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Grant Furick <furick1(at)attglobal(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: hierarchical order equivalent
Date: 2001-03-19 09:06:54
Message-ID: 20010319100653.A26000@ara.zf.jcu.cz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tubagus Nizomi 2001-03-19 10:13:40 MultiByte strings
Previous Message Tom Lane 2001-03-19 04:22:21 Re: What do I do with this error?