A couple of usage examples for the case statement

1 files changed, 9 insertions, 0 deletions

diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py
index 39a2ae3eb..9272e6d82 100644
--- a/lib/sqlalchemy/sql/expression.py
+++ b/lib/sqlalchemy/sql/expression.py
@@ -440,6 +440,15 @@ def case(whens, value=None, else_=None):
     or literal(<string>) constructs must be used to 
     interpret raw string values.
       
+    Usage examples::
+
+      case([(orderline.c.qty > 100, item.c.specialprice),
+            (orderline.c.qty > 10, item.c.bulkprice)
+          ], else_=item.c.regularprice)
+      case(value=emp.c.type, whens={
+              'engineer': emp.c.salary * 1.1,
+              'manager':  emp.c.salary * 3,
+          })
     """
     try:
         whens = util.dictlike_iteritems(whens)