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 it the first OpenSource DBMS to implement them I guess.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general