Re: hierarchical question - grabbing everything related

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Nov 2007 14:15:17 -0800
Message-ID: <1194473713.81338@bubbleator.drizzle.com>

SpaceMarine wrote:
> On Nov 6, 10:18 am, SpaceMarine <spacemar..._at_mailinator.com> wrote:
>

>> ...going to try that.

>
> this doesnt quite work. while it works for simple examples, a childID-
> based rowset doesnt allow for more than one childID per parent, which
> is no good. damn.
>
> very challenging.
>
> i have 20,000 product rows, w/ varying levels of hierarchies. i want
> to do a name-based search to get a subset of them, but i want it to
> list all of the returned rows' descendants too. this should be pretty
> doable.... but how!?

Given that you've chopped out previous posts the information that might have helped answer that question is now gone.

Daniel A. Morgan
University of Washington
damorgan ..._at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org Received on Wed Nov 07 2007 - 16:15:17 CST