blob: 067f74db4f6726508b93aac2ffd9134f252c715d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
--
-- SELECT_DISTINCT_ON
--
SELECT DISTINCT ON string4 two, string4, ten
FROM tmp
ORDER BY two using <, string4 using <, ten using <;
two | string4 | ten
-----+---------+-----
0 | AAAAxx | 0
0 | HHHHxx | 0
0 | OOOOxx | 0
0 | VVVVxx | 0
1 | AAAAxx | 1
1 | HHHHxx | 1
1 | OOOOxx | 1
1 | VVVVxx | 1
(8 rows)
|
