-- pg_docs
VALUES (1, 'one'), (2, 'two'), (3, 'three');

-- union_with_select
SELECT 1 AS column1, 'one' AS column2
UNION ALL
SELECT 2, 'two'
UNION ALL
SELECT 3, 'three';




-- insert_values
INSERT INTO films VALUES
    ('UA502', 'Bananas', 105, DEFAULT, 'Comedy', '82 minutes'),
    ('T_601', 'Yojimbo', 106, DEFAULT, 'Drama', DEFAULT);

-- in_select_from_position
SELECT f.*
  FROM films f, (VALUES('MGM', 'Horror'), ('UA', 'Sci-Fi')) AS t (studio, kind)
  WHERE f.studio = t.studio AND f.kind = t.kind;

-- update_from
UPDATE employees SET salary = salary * v.increase
FROM (VALUES(1, 200000, 1.2), (2, 400000, 1.4)) AS v (depno, target, increase)
WHERE employees.depno = v.depno AND employees.sales >= v.target;

-- select_from_in
SELECT * FROM machines
WHERE ip_address IN (VALUES('192.168.0.1'::inet), ('192.168.0.10'), ('192.168.1.43'));

-- trailing_clauses
values (2), (1) order by 1 limit 1 offset 1;
values (1) fetch first 1 row only;
values (1) for update;

-- union
values (1, 2) union values (3, 4);

-- union_select_values
values (1) union values (2) union select 3;

select (1) union values (2) union select 3;

