Mercurial > hg > MonetDB-extend

changeset 22:516363965869

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add example of join with flags.
author Sjoerd Mullender <sjoerd@acm.org>
date Tue, 23 Jan 2018 15:03:54 +0100 (2018-01-23)
parents 4623949ae9e4
children a0f0c7d6a38f
files regexp/README.rst
diffstat 1 files changed, 3 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/regexp/README.rst	Tue Jan 23 14:49:05 2018 +0100
+++ b/regexp/README.rst	Tue Jan 23 15:03:54 2018 +0100
@@ -73,12 +73,10 @@
 string vs. finding a matching substring.  The way we will be able to
 call this variant is::
 
+  SELECT ['some string'] sys.rematch ['.*foo.*', 'i'];
   SELECT name FROM t WHERE [name] sys.rematch ['.*foo.*', 'i'];
-
-This particular query will be equivalent to both::
-
-  SELECT name FROM t WHERE name ILIKE '%foo%';
-  SELECT name FROM t WHERE [name] sys."ilike" ['%foo%'];
+  SELECT t1.value FROM t1 JOIN t2 ON [t1.value] sys.rematch [t2.pattern, 'i'];
+  SELECT t1.value FROM t1, t2 WHERE [t1.value] sys.rematch [t2.pattern, 'i'];
 
 Implementation
 --------------