Viktor,
The implementation is there in the MonetDB backend, the module that implements it is pcre (to be found in MonetDB5 source tree).
I'm not sure whether it is available by default from MonetDB/SQL.
If not, with these two function definition, you link SQL functions to the respective implementations in MonetDB5:
-- case sensitive
create function pcre_match(s string, pattern string)
returns BOOLEAN
external name pcre.match;
-- case insensitive
create function pcre_imatch(s string, pattern string)
returns BOOLEAN
external name pcre.imatch;
If you need more, I'd suggest to have a look at MonetDB5/src/modules/mal/
pcre.mx in the source code.
Cheers, Roberto
On Fri, Aug 19, 2011 at 23:44, Viktor Rosenfeld
<listuser36@googlemail.com> wrote:
Hi,
does MonetDB support regular expression matching on strings? It's
supposedly part of SQL:99, but I couldn't find anything about this on
the homepage or the mailing list.
I only found the Data Manipulation reference, which lists LIKE
predicates.
Cheers,
Viktor
------------------------------------------------------------------------------
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users