Re: hierachal or tree type queries using OLWGS

Joe Freeman wrote: > > We have a table which has parent_id pointer which points up to the same > table so that we can buld a tree of data in the table. (Each child > points to its parent). I'd like to write a query that finds a node in > the tree and all its decendants. Is there any support for this type of > query in informix? (I think Oracle and one of the MS products has > something called hierarchal cursors to do this) > <SNIP> You can implement this by using a stored procedure that calls itself recursively. I can post an example if you need more information. Regards, Roland