From 6d2d5e923ee32eeea3918d2672f54dff253b253f Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Fri, 11 Jan 2008 21:24:01 +0000
Subject: - added "ilike()" operator to column operations. compiles to ILIKE on
 postgres, lower(x) LIKE lower(y) on all others [ticket:727]

---
 lib/sqlalchemy/databases/postgres.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'lib/sqlalchemy/databases')

diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py
index 19db8b6b7..bab998d69 100644
--- a/lib/sqlalchemy/databases/postgres.py
+++ b/lib/sqlalchemy/databases/postgres.py
@@ -625,7 +625,8 @@ class PGCompiler(compiler.DefaultCompiler):
     operators = compiler.DefaultCompiler.operators.copy()
     operators.update(
         {
-            sql_operators.mod : '%%'
+            sql_operators.mod : '%%',
+            sql_operators.ilike_op: 'ILIKE'
         }
     )
 
-- 
cgit v1.2.1