Common Table Expression (CTE)

A way of writing subqueries for use in a larger SELECT query.

A Common Table Expression (CTE) is a way of writing subqueries for use in a larger SELECT query, using a WITH clause.

Common Table Expressions were added in PostgreSQL 8.4 (commit 44d5be0e).

Change history

Categories

DML