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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
