8.48. VALUES

Synopsis

  1. VALUES row [, ...]

where row is a single expression or

  1. ( column_expression [, ...] )

Description

Defines a literal inline table.

VALUES can be used anywhere a query can be used (e.g., the FROM clauseof a SELECT, an INSERT, or even at the top level). VALUES createsan anonymous table without column names, but the table and columns can be namedusing an AS clause with column aliases.

Examples

Return a table with one column and three rows:

  1. VALUES 1, 2, 3

Return a table with two columns and three rows:

  1. VALUES
  2.     (1, 'a'),
  3.     (2, 'b'),
  4.     (3, 'c')

Return table with column id and name:

  1. SELECT * FROM (
  2.     VALUES
  3.         (1, 'a'),
  4.         (2, 'b'),
  5.         (3, 'c')
  6. ) AS t (id, name)

Create a new table with column id and name:

  1. CREATE TABLE example AS
  2. SELECT * FROM (
  3.     VALUES
  4.         (1, 'a'),
  5.         (2, 'b'),
  6.         (3, 'c')
  7. ) AS t (id, name)

See Also

INSERT, SELECT