diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-03-19 19:35:42 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2008-03-19 19:35:42 +0000 |
| commit | 0cc04e6e1b70abc4817f275a898aa063da3de007 (patch) | |
| tree | ef3635ca30317f49fa296deea56a263dad2d8167 /lib/sqlalchemy/databases/postgres.py | |
| parent | a86dc8cbac51893e400e9e49f5e9d358c9845897 (diff) | |
| download | sqlalchemy-0cc04e6e1b70abc4817f275a898aa063da3de007.tar.gz | |
- like() and ilike() take an optional keyword argument
"escape=<somestring>", which is set as the escape character
using the syntax "x LIKE y ESCAPE '<somestring>'"
[ticket:993]
Diffstat (limited to 'lib/sqlalchemy/databases/postgres.py')
| -rw-r--r-- | lib/sqlalchemy/databases/postgres.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py index 10f384475..a34388a89 100644 --- a/lib/sqlalchemy/databases/postgres.py +++ b/lib/sqlalchemy/databases/postgres.py @@ -641,8 +641,8 @@ class PGCompiler(compiler.DefaultCompiler): operators.update( { sql_operators.mod : '%%', - sql_operators.ilike_op: 'ILIKE', - sql_operators.notilike_op: 'NOT ILIKE' + sql_operators.ilike_op: lambda x, y, escape=None: '%s ILIKE %s' % (x, y) + (escape and ' ESCAPE \'%s\'' % escape or ''), + sql_operators.notilike_op: lambda x, y, escape=None: '%s NOT ILIKE %s' % (x, y) + (escape and ' ESCAPE \'%s\'' % escape or ''), } ) |