diff options
Diffstat (limited to 'lib/sqlalchemy/sql.py')
-rw-r--r-- | lib/sqlalchemy/sql.py | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py index 4ec7cbb7b..dcf153866 100644 --- a/lib/sqlalchemy/sql.py +++ b/lib/sqlalchemy/sql.py @@ -399,7 +399,11 @@ class ClauseElement(object): """executes this SQL expression via the execute() method, then returns the first column of the first row. Useful for executing functions, sequences, rowcounts, etc.""" - return self.execute(*multiparams, **params).fetchone()[0] + row = self.execute(*multiparams, **params).fetchone() + if row is not None: + return row[0] + else: + return None def __and__(self, other): return and_(self, other) |