Recursive stored procedures

[Ruslan Zasukhin]

On 1/21/09 10:57 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

> hmmm, I know I rather would not use it, but I am looking for a way to
> search a table that has the 'adjacent tree' model
> 
> like
> recid-somefields-objptr_parentid
> 
> 1-blabla-null
> 2-bll-1
> 3-hi-null
> 4-dhsi-2
> 
> and now I need a select that given recid 1 wil return the recids 1,2,4
> and this for a unknown depth of nesting.
> It looks like I would need recursive joins (which I don't see
> available in Valentina SQL) or a recursive procedure.
> 
> Still think this should be doable using the correct joins and where
> statements and only one select, just don't see how for the moment.
> Flue does not help either.

Please read my letter about 10 days ago
About HOW we going to solve this task/


It is not right way use recursive SP here!
Because on big table will be problems.

Only even if do SPs -- like in loop

But of course we need implement it as I have describe few days ago





-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]