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.

Support for Common Table Expressions was added in PostgreSQL 8.4.

Change history

Categories

DML

See also

recursive query