Subject Re: [firebird-support] CTE in PSQL?
Author Thomas Steinmaurer

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


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