Mastering PostgreSQL 12 - Third Edition

Using the WITH RECURSIVE clause

The WITH clause comes in two forms:

• Standard CTEs, as shown in the previous section (using the WITH clause)
• A method to run recursions in SQL

The simple form of a CTE was covered in the previous section. In the next section, the recursive version will be covered.