From 90786906ee3bce15c83445c0ba25a69a6b7e115d Mon Sep 17 00:00:00 2001
From: Boris Kolpackov <boris@codesynthesis.com>
Date: Thu, 21 Feb 2013 11:07:25 +0200
Subject: Add support for pattern matching (SQL LIKE)

---
 odb/pgsql/query-dynamic.cxx | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'odb/pgsql/query-dynamic.cxx')

diff --git a/odb/pgsql/query-dynamic.cxx b/odb/pgsql/query-dynamic.cxx
index ba38758..bd2c949 100644
--- a/odb/pgsql/query-dynamic.cxx
+++ b/odb/pgsql/query-dynamic.cxx
@@ -110,6 +110,22 @@ namespace odb
           q += ")";
           break;
         }
+      case part::op_like:
+        {
+          translate (q, s, p - 2); // column
+          q += "LIKE";
+          translate (q, s, p - 1); // pattern
+          break;
+        }
+      case part::op_like_escape:
+        {
+          translate (q, s, p - 3); // column
+          q += "LIKE";
+          translate (q, s, p - 2); // pattern
+          q += "ESCAPE";
+          translate (q, s, p - 1); // escape
+          break;
+        }
       case part::op_eq:
       case part::op_ne:
       case part::op_lt:
-- 
cgit v1.1