From bfbbb2afb1137bfa3efe381356b5bf620036737c Mon Sep 17 00:00:00 2001 From: Rick Morrison Date: Thu, 15 Mar 2007 01:58:46 +0000 Subject: fix CASE statement when else_ is zero --- lib/sqlalchemy/sql.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py index 831240697..d48e385f2 100644 --- a/lib/sqlalchemy/sql.py +++ b/lib/sqlalchemy/sql.py @@ -243,7 +243,7 @@ def case(whens, value=None, else_=None): """ whenlist = [_CompoundClause(None, 'WHEN', c, 'THEN', r) for (c,r) in whens] - if else_: + if not else_ is None: whenlist.append(_CompoundClause(None, 'ELSE', else_)) cc = _CalculatedClause(None, 'CASE', value, *whenlist + ['END']) for c in cc.clauses: -- cgit v1.2.1