Subject | CTE in PSQL? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-09-29T20:19:36Z |
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 ...
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/
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 ...
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/