Hello Philippe,

Check the following document:

http://www.onlamp.com/pub/a/onlamp/2004/08/05/hierarchical_sql.html

Sélim

> -----Original Message-----
> From: A6-CMO Philippe Makowski [mailto:makowski@...]
> Subject: [firebird-support] Hierarchical data structures
>
> Hello,
> In the programm of the International PHP Conference 2004
> I see that there is a a session by Ard Biesheuvel
> "Hierarchical data structures in SQL (Language: English)
>
> The SQL relational model maps poorly to hierarchical data structures like
> file
> systems and web forums. Oracle uses START WITH/CONNECT BY to emulate
> hierarchy.
> This functionality and more can be added to a Firebird database by
> employing
> recursive selectable stored procedures."
>
> Any one know where can I get such material ?
> (I can wait or go to this conference)
>
> --
> Philippe Makowski