--- In firebird-support@yahoogroups.com, "josephhirn"
<josephhirn@y...> wrote:

>
> I need a query/procedure that will return depth first enumeration of
> the leaf nodes in a hierarchial structure stored in my database.
> Ultimately this procedure will be called via JDBC and I would like it
> to return a single result set in the proper order.
>
>
> Any help is greatly appreciated. Thanks a ton in advance!
>

Recusively call a selectable stored procedure that starts the collapse
when it reaches the lowest point of your tree
Mick