> I have table which has parent-child relationships between rows. How
> can I write a query (stored procedure) that given a parent id selects
> all childs?
>
> Firebird server 2.1

With 2.1 even easier. Lookup recursive CTE in the Release notes. You
don't need a recursive stored procedure anymore.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/