Thanx for the response Milan.

I had thought of that but wouldn't a recursive stored procedure incur
an even bigger overhead? As each level fires a select statement that
has to run for each row returned?

Cheers

Chris


--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...>
wrote:

>
> chrisacron wrote:
> > In my application I use a self-related table to define complex
> > classifications. The number of levels are theoretically unlimited but
> > in reality will probably be 10-15 maximum.
> > Is there another way of doing this?
>
> Write a recursive stored procedure?
>
> With recursive SP you are not limited and go to any depth (or whatever
> is the limitation of stack space).
>
> --
> Milan Babuskov
> http://swoes.blogspot.com/
> http://www.flamerobin.org
>