diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-01-11 21:30:02 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-01-11 21:30:02 +0000 |
| commit | 05a693fcb7a57f0362e06da1517cb35279bfaad1 (patch) | |
| tree | 7b4b9f855c008274978921942eff461030e5d43e /lib/sqlalchemy | |
| parent | 6d2d5e923ee32eeea3918d2672f54dff253b253f (diff) | |
| download | sqlalchemy-05a693fcb7a57f0362e06da1517cb35279bfaad1.tar.gz | |
fixed NOT ILIKE
Diffstat (limited to 'lib/sqlalchemy')
| -rw-r--r-- | lib/sqlalchemy/databases/postgres.py | 3 | ||||
| -rw-r--r-- | lib/sqlalchemy/sql/compiler.py | 2 |
2 files changed, 3 insertions, 2 deletions
diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index bab998d69..220c2a487 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -626,7 +626,8 @@ class PGCompiler(compiler.DefaultCompiler): operators.update( { sql_operators.mod : '%%', - sql_operators.ilike_op: 'ILIKE' + sql_operators.ilike_op: 'ILIKE', + sql_operators.notilike_op: 'NOT ILIKE' } ) diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index 545c0a1b4..8f2e3372a 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -80,7 +80,7 @@ OPERATORS = { operators.like_op : 'LIKE', operators.notlike_op : 'NOT LIKE', operators.ilike_op : lambda x, y: "lower(%s) LIKE lower(%s)" % (x, y), - operators.notilike_op : 'NOT ILIKE', + operators.notilike_op : lambda x, y: "lower(%s) NOT LIKE lower(%s)" % (x, y), operators.between_op : 'BETWEEN', operators.in_op : 'IN', operators.notin_op : 'NOT IN', |