blob: 20c73280d626bf1e1371448b89fe078bd67fddab (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
(SELECT * FROM (VALUES (1), (3)) AS t (x))
UNION
(SELECT * FROM (VALUES (2)) AS t (x))
EXCEPT
SELECT * FROM (VALUES (3)) AS t (x)
ORDER BY x;
(SELECT * FROM (VALUES (1), (3)) AS t (x) ORDER BY x LIMIT 4)
UNION
(SELECT * FROM (VALUES (2)) AS t (x) ORDER BY x LIMIT 4)
EXCEPT
SELECT * FROM (VALUES (3)) AS t (x)
ORDER BY x;
|
