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.comwrote:

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