← Back to branch summary

~vcs-imports/mammoth-replicator/trunk

« back to all changes in this revision

Viewing changes to src/test/regress/sql/select_distinct_on.sql

  • Committer: alvherre
  • Date: 2005-12-16 21:24:52 UTC
  • Revision ID: svn-v4:db760fc0-0f08-0410-9d63-cc6633f64896:trunk:1
Initial import of the REL8_0_3 sources from the Pgsql CVS repository.

Show diffs side-by-side

added added

removed removed

Lines of Context:
src/test/regress/sql/select_distinct_on.sql
 
1
--
 
2
-- SELECT_DISTINCT_ON
 
3
--
 
4
 
 
5
SELECT DISTINCT ON (string4) string4, two, ten
 
6
   FROM tmp
 
7
   ORDER BY string4 using <, two using >, ten using <;
 
8
 
 
9
-- this will fail due to conflict of ordering requirements
 
10
SELECT DISTINCT ON (string4, ten) string4, two, ten
 
11
   FROM tmp
 
12
   ORDER BY string4 using <, two using <, ten using <;
 
13
 
 
14
SELECT DISTINCT ON (string4, ten) string4, ten, two
 
15
   FROM tmp
 
16
   ORDER BY string4 using <, ten using >, two using <;