3 ms·
> This is not a problem if your DBMS supports SQL recursion A table of which DMBS’s support this would be useful
by urbandw311er 6y ago
> This is not a problem if your DBMS supports SQL recursion
A table of which DMBS’s support this would be useful
- alexf95 6y agoThis is the list that i could find: Microsoft SQL Server, Firebird 2.1, PostgreSQL, SQLite, IBM Informix version, CUBRID, MariaDB and MySQL
- geogra4 6y agoNot oracle?
- exdsq 6y agoI sort of assumed all of them did!
- Twisell 6y agoNot sure if it's up-to date though : https://modern-sql.com/caniuse/with_recursive_(top_level) https://modern-sql.com/caniuse/with_recursive_(top_level)
- nalgeon 6y agoWITH RECURSIVE is supported in MariaDB 10.2+, MySQL 8.0+, PostgreSQL 8.4+ and SQLite 3.8+. Oracle 11.2+ and SQL Server 2005 support recursive queries, but without the RECURSIVE keyword.
- dspillett 6y agoBefore recent versions, in the Postgres implementation CTEs were a wall to predicate push-down which can make them much less efficient than in other DBMSs. Worth noting if you need to support older versions for any reason.
- jeltz 6y agoYeah, but recursive CTEs are a different beast and still do not support pushdown. I am not sure if any database supports pushdown into recursive CTEs.
- magicalhippo 6y agoFWIW Sybase SQL Anywhere has supported it since v10[1] at least. Current version is v17[2]. [1]: http://dcx.sap.com/index.html#1001/en/dbrfen10/rf-select-statement.html http://dcx.sap.com/index.html#1001/en/dbrfen10/rf-select-sta... [2]: http://dcx.sap.com/index.html#sqla170/en/html/8190aea36ce210148ba08e45121e72af.html http://dcx.sap.com/index.html#sqla170/en/html/8190aea36ce210...