From 2c95c39e9345ef50a7e9c3ad573857b1d358e04a Mon Sep 17 00:00:00 2001 From: Kazuya NUMATA Date: Thu, 25 Dec 2014 12:58:42 +0900 Subject: {Matches,DoesNotMatch} support the ESCAPE clause with PostgreSQL to_SQL already has supported the ESCAPE clause in #318. PostgreSQL can use the ESCAPE clause too. --- lib/arel/visitors/postgresql.rb | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) (limited to 'lib') diff --git a/lib/arel/visitors/postgresql.rb b/lib/arel/visitors/postgresql.rb index f55aaf30fe..bd23fc0a47 100644 --- a/lib/arel/visitors/postgresql.rb +++ b/lib/arel/visitors/postgresql.rb @@ -4,11 +4,23 @@ module Arel private def visit_Arel_Nodes_Matches o, collector - infix_value o, collector, ' ILIKE ' + collector = infix_value o, collector, ' ILIKE ' + if o.escape + collector << ' ESCAPE ' + visit o.escape, collector + else + collector + end end def visit_Arel_Nodes_DoesNotMatch o, collector - infix_value o, collector, ' NOT ILIKE ' + collector = infix_value o, collector, ' NOT ILIKE ' + if o.escape + collector << ' ESCAPE ' + visit o.escape, collector + else + collector + end end def visit_Arel_Nodes_Regexp o, collector -- cgit v1.2.3