aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/select_distinct_on.out
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)