added distinct() function to column elements for "DISTINCT <col>"

2 files changed, 3 insertions, 0 deletions

diff --git a/CHANGES b/CHANGES
index 8810b1db1..8995de9d3 100644
--- a/CHANGES
+++ b/CHANGES
@@ -3,6 +3,7 @@
 blown away if it hadnt been loaded
 - added unique_connection() method to engine, connection pool to return a connection
 that is not part of the thread-local context or any current transaction
+- added distinct() function to column elements so you can do func.count(mycol.distinct())
 
 0.1.4
 - create_engine() now uses genericized parameters; host/hostname, db/dbname/database, 
diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py
index f78d4fa73..b88cf18cd 100644
--- a/lib/sqlalchemy/sql.py
+++ b/lib/sqlalchemy/sql.py
@@ -490,6 +490,8 @@ class CompareMixin(object):
         return self._compare('LIKE', "%" + str(other))
     def label(self, name):
         return Label(name, self)
+    def distinct(self):
+        return CompoundClause(None,"DISTNCT", self)
     def op(self, operator):
         return lambda other: self._compare(operator, other)
     # and here come the math operators: