Re: Hierachical structures - an overview

Lennart Jonsson wrote:
>
> "Mike MacSween" <mike.macsween.nospam_at_btinternet.com> wrote in message news:<3ff7e63a$0$52881$5a6aecb4@news.aaisp.net.uk>...
> > I have an app I need a hierachical structure for. There seem to be 3 ways of
> > implementing this, as far as I can see:
> >
> ....
> > Any other techniques?
> >
>
> Recursive SQL. It is supported by atleast two databases, DB2 (WITH)
> and Oracle (CONNECT BY).

Recursive SQL is also supported by FirstSQL/J (see my sig). It uses an Oracle-like CONNECT BY syntax.

-- 
Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)