PostgreSQL

Скачать в pdf «PostgreSQL»


union Clause


The SQL92 syntax for UNION allows an additional CORRESPONDING BY clause: table_query UNION [ALL] [CORRESPONDING [BY (column [,…])]] table_query The CORRESPONDING BY clause is not supported by Postgres.

D.79 SELECT INTO


Name


SELECT INTO — Create a new table from an existing table or view SELECT [ ALL I DISTINCT [ ON (expression [,…] ) ] ]


expression [ AS name ][,…]


[ INTO [ TEMPORARY I TEMP ] [ TABLE ] newjable ]


[FROM table [ alias ] [,…] ]


[ WHERE condition ]


[GROUP BY column [,…] ]


[HAVINGcondition [,…] ]


[ { UNION [ ALL ] | INTERSECT | EXCEPT } select ]


[ORDER BY column [ASC | DESC | USING operator ] [,…] ]


[ FOR UPDATE [ OF class_name [,…] ] ]


[ LIMIT { count | ALL } [ { OFFSET | , } start ] ]


Inputs


All input fields are described in detail for SELECT.


Outputs


All output fields are described in detail for SELECT.


Description


SELECT INTO creates a new table from the results of a query. Typically, this query draws data from an existing table, but any SQL query is allowed. Note: CREATE TABLE AS is functionally equivalent to the SELECT INTO command.

d.80 SET


Name


SET — Set run-time parameters for session


SET variable { TO | = } { value | ’value ’ | DEFAULT }


SET CONSTRAINTS { ALL | eonstraintlist } mode SET TIME ZONE { ’timezone ’ | LOCAL | DEFAULT }

Скачать в pdf «PostgreSQL»