<phrase>and <replaceable class="parameter">with_query</replaceable> is:</phrase>

<replaceable class="parameter">with_query_name</replaceable> [ ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ] AS ( <replaceable class="parameter">select</replaceable> | <replaceable class="parameter">insert</replaceable> | <replaceable class="parameter">update</replaceable> | <replaceable class="parameter">delete</replaceable> )

<replaceable class="parameter">with_query_name</replaceable> [ ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ] AS ( <replaceable class="parameter">select</replaceable> | <replaceable class="parameter">values</replaceable> | <replaceable class="parameter">insert</replaceable> | <replaceable class="parameter">update</replaceable> | <replaceable class="parameter">delete</replaceable> )

TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ]

</synopsis>

subqueries that can be referenced by name in the primary query.

The subqueries effectively act as temporary tables or views

for the duration of the primary query.

Each subquery can be a <command>SELECT</command>,

Each subquery can be a <command>SELECT</command>, <command>VALUES</command>,

<command>INSERT</command>, <command>UPDATE</command> or

<command>DELETE</command> statement.

When writing a data-modifying statement (<command>INSERT</command>,