From 5ca0c9a45788a14b9f454c93cd24fb0ae12a896b Mon Sep 17 00:00:00 2001 From: Ernie Miller Date: Wed, 29 Sep 2010 15:50:24 -0400 Subject: Make PostgreSQL play nice with its friends. (matches -> ILIKE instead of LIKE) --- lib/arel/visitors/postgresql.rb | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/lib/arel/visitors/postgresql.rb b/lib/arel/visitors/postgresql.rb index 87fc3bd60d..5e03f40984 100644 --- a/lib/arel/visitors/postgresql.rb +++ b/lib/arel/visitors/postgresql.rb @@ -21,6 +21,14 @@ module Arel end end + def visit_Arel_Nodes_Matches o + "#{visit o.left} ILIKE #{visit o.right}" + end + + def visit_Arel_Nodes_DoesNotMatch o + "#{visit o.left} NOT ILIKE #{visit o.right}" + end + def using_distinct_on?(o) o.cores.any? do |core| core.projections.any? do |projection| -- cgit v1.2.3