[SQL-CVS] [ sqlobject-Patches-1410834 ] add RLIKE operator

[SourceForge.net <no...@so...>]

Patches item #1410834, was opened at 2006-01-20 15:21
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1410834&group_id=74338

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Pau Aliagas (linux4u)
Assigned to: Nobody/Anonymous (nobody)
Summary: add RLIKE operator

Initial Comment:
Well, it looks like I'm inspired.

I tried to do all the regular expression matching in
python, but it was too slow, as I need to select
records based on an expresion matching.

So I have implemented RLIKE, also known as REGEXP or
Posix Regular Expressions. You can use it as any other
operator!

mysql and firebird call it REGEXP and RLIKE
postgres calls it ~

The rest just do not support it, so I've made it behave
like "LIKE", as I did not find a standard manner not to
support it. It's not a bad solution :)

The patch is really trivial, I've tested it with many
records (in mysql) and works as expected. I've tested
the resulting SQL in postgres and it works too.

Hope you can include it.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1410834&group_id=74338