src/test/regress/sql/select_distinct_on.sql


1
2
3
4
5
6
7
8

--
-- test select distinct on
--
SELECT DISTINCT ON string4 two, string4, ten
	   FROM tmp
   ORDER BY two using <, string4 using <, ten using <;