Hi!

>> Hello,
>>
>> the Firebird 2.1 release notes state that CTE are available in PSQL, but
>> I don't find a way to have a recursive CTE in a stored procedure which
>> I'm able to iterate through in e.g. a FOR SELECT ...
>
> Here's an example of a recursive CTE in a procedure:

Ah, ok. Using CTE directly in a FOR clause.

Thanks!


--
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/