Subject Re: [firebird-support] CTE in PSQL?
Author unordained
---------- 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:

for with recursive x as (... union ...) select ... from x into ... do

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