aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/select_distinct_on.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/select_distinct_on.out')
-rw-r--r--src/test/regress/expected/select_distinct_on.out15
1 files changed, 15 insertions, 0 deletions
diff --git a/src/test/regress/expected/select_distinct_on.out b/src/test/regress/expected/select_distinct_on.out
new file mode 100644
index 00000000000..172cec55d8d
--- /dev/null
+++ b/src/test/regress/expected/select_distinct_on.out
@@ -0,0 +1,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)
+