From: Vrin26 <email@example.com>
Sent: Sun, October 11, 2009 10:25:41 PM
Subject: Re: Recursive query on common table
I am trying to create a hierarchy tree structure.
In my table I have columns Parent and Child.
Parent column can also have child ids and it's subchild ids in Child column.
I need to loop over table until i get chain of all parent, child, subchilds
and so on.
I don't have information about number of childs a parent can have, so I have
to loop until i don't get any more childs for parent.
Is there a way to achive this in Derby database?
Geoffrey Hendrey wrote:
> Could you give some more detail on what the query will be used for?
> On Oct 9, 2009, at 4:52 AM, Vrin26 <firstname.lastname@example.org
> I need to do a recursive query on a single derby database table.
> In Derby database documents
it is mentioned that this derby doesn't
> recursive queries.
> Is there any other work around to handle this scenario?
> View this message in context:> http://www.nabble.com/Recursive-query-on-common-table-tp25819772p25819772.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com
-- View this message in context: http://www.nabble.com/Recursive-query-on-common-table-tp25819772p25850680.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.