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
I am trying to build a hierarchy of inter-related categories. I want an
easy way to output the tree. Any ideas?
Thanks,
Grant
---------------------------(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
