<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.110 2008/11/20 14:04:45 petere Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.111 2008/11/21 11:47:55 petere Exp $

PostgreSQL documentation

-->

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

TABLE <replaceable class="parameter">table_name</replaceable> | <replaceable class="parameter">with_query_name</replaceable>

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

</synopsis>

</refsynopsisdiv>

$$ = (Node *)n;

}

| values_clause{$$ =$1; }

| TABLEqualified_name

| TABLErelation_expr

{

ColumnRef *cr = makeNode(ColumnRef);

ResTarget *rt = makeNode(ResTarget);

SelectStmt *n = makeNode(SelectStmt);

rt->val = (Node *)cr;

rt->location = -1;

$2->inhOpt = INH_DEFAULT;

$2->alias =NULL;

n->targetList = list_make1(rt);

n->fromClause = list_make1($2);

$$ = (Node *)n;