On Tue, 2 Sep 2014 15:34:33 +0300, marius adrian popa <map...@gmail.com> wrote: > MariaDB switched to the PCRE regular expression library > > https://mariadb.com/kb/en/mariadb/documentation/functions-and-operators/string-functions/regular-expressions-functions/pcre-regular-expressions/+source/ > > I wonder how hard it will be to switch to it ? > > Idea from Jiri > > https://twitter.com/cincura_net/status/506736533341491201
MariaDB switched from another Posix regex library, while Firebird uses - afaik - the regex defined in the SQL standard. The changes by MariaDB are - mostly - backwards compatible with their previous library so this changes will most likely not affect current code. For Firebird to change this would fundamentally change the regex syntax introducing 1) incompatibilities and 2) not be according to the SQL standard. If we are to introduce another regex syntax that should be a vendor specific extension, similar to what PostgreSQL does: SIMILAR TO: http://www.postgresql.org/docs/9.3/interactive/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP Posix Regex: http://www.postgresql.org/docs/9.3/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
