Supporting the WITH RECURSIVE clause

The following list shows which engines support the WITH RECURSIVE clause and which don't:

  • MariaDB: Not supported
  • MySQL: Not supported
  • PostgreSQL: Supported since PostgreSQL 8.4
  • SQLite: Supported since 3.8.3
  • Db2 LUW: Supported since 7 (2000)
  • Oracle: Supported since 11gR2 (in Oracle, it is usually more common to use the CONNECT BY clause instead of the WITH RECURSIVE clause)
  • Microsoft SQL Server: Supported since 2005
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset