blob: 172cec55d8da0ad96418874853fa8ad3f37cbde7 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
QUERY: SELECT DISTINCT ON string4 two, string4, ten
FROM temp
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)
|