On Fri, 19 May 2006 17:44:45 GMT, "Paul McGuire" <[EMAIL PROTECTED]> wrote:
> "Gerhard Häring" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> """ >> The REGEXP operator is a special syntax for the regexp() user >> function. No regexp() user function is defined by default and so use >> of the REGEXP operator will normally result in an error message. If a >> user-defined function named "regexp" is defined at run-time, that >> function will be called in order to implement the REGEXP operator. >> """ > This is very interesting. So I *could* define my own regexp function > that processes not regular expressions, but say, glob-like strings, > which are usually much easier for end users to work with (very basic > wild-carding where '*' matches one or more characters, and '?' matches > any single character - maybe add '#' to match any single digit and '@' > to match any single alpha character). Doesn't SQL already have lightweight wildcards? SELECT somefield FROM sometable WHERE someotherfield LIKE '%foo%' Regards, Dan -- Dan Sommers <http://www.tombstonezero.net/dan/> "I wish people would die in alphabetical order." -- My wife, the genealogist -- http://mail.python.org/mailman/listinfo/python-list
