Small. Fast. Reliable.
Choose any three.

with-clause

WITH RECURSIVE cte-table-name AS NOT MATERIALIZED ( select-stmt ) MATERIALIZED ,



References:   cte-table-name   select-stmt

See also:   lang_with.html