David Fetter, 13.07.2009 16:32:
>> START WITH is Oracle specific whereas recursive CTEs are an ANSI
>> Standard (supported by PostgreSQL, Firebird and SQL Server).
>
> Not to mention DB2. I'm not sure how close Firebird is to actually
> shipping them...
Interesting, didn't know DB2 had them as well.
Firebird implemented recursive CTEs with Version 2.1 which was released April, 2008, more than a year ago. Which makes
itthe first OpenSource DBMS to implement them I guess.
Thomas