Re: [SQL] hierarchical order equivalent

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 b

[SQL] hierarchical order equivalent

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 categori