3 ms·
So essentially this is Oracle SQL - does anyone know if there are analogous similar START WITH and CONNECT BY keywords for other platforms? (author mentions MSS
by r00fus 12y ago
So essentially this is Oracle SQL - does anyone know if there are analogous similar START WITH and CONNECT BY keywords for other platforms? (author mentions MSSQL has the them, but no mention of MySQL/MariaDB or PGSQL).
- spacemanmatt 12y agoThey're nice to have but you can do some or all the same things using recursive CTE in PostgreSQL, for one.
- dragonwriter 12y agoRecursive CTEs are strictly more powerful than Oracle's START WITH/CONNECT BY and are supported by most databases (pretty much everything other than the MySQL/MariaDB family -- SQLServer, Oracle, Postgres, even SQlite.) To be fair to Oracle, START WITH/CONNECT BY has been available in Oracle a lot longer than CTEs as part of the SQL standard have existed.
- crorella 12y agoTeradata has the WITH RECURSIVE statement which is pretty easy to use.
- batbomb 12y agoNo support in MySQL/MariaDB. There is support in Postgres, sqlite, MSSQL, HSQLDB, Oracle, etc... for CTEs. You can sort of emulate some recursive SQL properties using a temporary table: http://brianv0.github.io/blog/2013/6/recursive.html http://brianv0.github.io/blog/2013/6/recursive.html