---------- Original Message -----------
From: Thomas Steinmaurer <ts@...>
Sent: Wed, 29 Sep 2010 22:19:36 +0200
Subject: [firebird-support] CTE in PSQL?

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

------- End of Original Message -------

Can you give us an example of what you're attempting and/or errors you're
getting? I'm assuming it's something like:

begin
for with recursive x as (... union ...) select ... from x into ... do
suspend;
end

Also, have you tried explicitly declaring/opening/fetching/closing cursors? That
might support syntax not supported by 'for select', I don't know.

-Philip