Contents
VALUES
A DML command for computing a set of rows
VALUES is a DML command for computing a set of rows.
VALUES was added in PostgreSQL 8.2.
Change history
- PostgreSQL 8.4
OFFSET start [ ROW | ROWS ]/FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLYSQL:2008 syntax added (commit 361bfc35)
- PostgreSQL 8.2
Examples
Basic usage example for VALUES:
postgres=# VALUES(1, 'foo'), (2, 'bar'), (3, 'baz');
column1 | column2
---------+---------
1 | foo
2 | bar
3 | baz
(3 rows)
References
- PostgreSQL documentation: VALUES
Categories
See also
SELECT