pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
hierarchical order equivalent
2+ messages / 2 participants
[nested] [flat]

* hierarchical order equivalent
@ 2001-03-18 23:56 Grant Furick <furick1@attglobal.net>
  2001-03-19 09:06 ` Re: hierarchical order equivalent Karel Zak <zakkr@zf.jcu.cz>
  0 siblings, 1 reply; 2+ messages in thread

From: Grant Furick @ 2001-03-18 23:56 UTC (permalink / raw)
  To: pgsql-sql

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: hierarchical order equivalent
  2001-03-18 23:56 hierarchical order equivalent Grant Furick <furick1@attglobal.net>
@ 2001-03-19 09:06 ` Karel Zak <zakkr@zf.jcu.cz>
  0 siblings, 0 replies; 2+ messages in thread

From: Karel Zak @ 2001-03-19 09:06 UTC (permalink / raw)
  To: Grant Furick <furick1@attglobal.net>; +Cc: 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@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-19 09:06 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-18 23:56 hierarchical order equivalent Grant Furick <furick1@attglobal.net>
2001-03-19 09:06 ` Karel Zak <zakkr@zf.jcu.cz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox