diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-01-11 21:24:01 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-01-11 21:24:01 +0000 |
| commit | 6d2d5e923ee32eeea3918d2672f54dff253b253f (patch) | |
| tree | 8871b7058759a2cf60a88c4e07cc70d806c2f9be /lib/sqlalchemy/sql/compiler.py | |
| parent | 664ba4467901df344e915cb50663548c74a703c6 (diff) | |
| download | sqlalchemy-6d2d5e923ee32eeea3918d2672f54dff253b253f.tar.gz | |
- added "ilike()" operator to column operations.
compiles to ILIKE on postgres, lower(x) LIKE lower(y)
on all others [ticket:727]
Diffstat (limited to 'lib/sqlalchemy/sql/compiler.py')
| -rw-r--r-- | lib/sqlalchemy/sql/compiler.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index 35a12efe3..545c0a1b4 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -79,7 +79,7 @@ OPERATORS = { operators.concat_op : '||', operators.like_op : 'LIKE', operators.notlike_op : 'NOT LIKE', - operators.ilike_op : 'ILIKE', + operators.ilike_op : lambda x, y: "lower(%s) LIKE lower(%s)" % (x, y), operators.notilike_op : 'NOT ILIKE', operators.between_op : 'BETWEEN', operators.in_op : 'IN', |