Thanks for the inputs experts, I am using SQLite 3.4.0 on Mac OS X Leapord, and using regexp in my query reports an error
SQL error: no such function: regexp I tried to use the query using GLOB and another query which separates FilePath into Dirpath and FileName and uses LIKE comparison. Both seems to be working fine. Is this the optimized query one could achieve for this problem? Is there any other way which I could retrieve results much faster than the two queries I have mentioned above? Thanks & Regards, Bharath On 1/29/08 12:11 AM, "James Dennett" <[EMAIL PROTECTED]> wrote: >> -----Original Message----- >> From: Nicolas Williams [mailto:[EMAIL PROTECTED] >> Sent: Monday, January 28, 2008 10:35 AM >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] How to specify regular expression in a query? >> >> On Mon, Jan 28, 2008 at 06:22:08PM +0100, Ralf Junker wrote: >>> I believe that this API would also ease implementations of Unicode >>> LIKE and GLOB. >> >> That's what I was thinking of. The Unicode extensions work by >> redefining the like, glob and regexp functions, and by adding >> collations. But surely the existing user-defined functions interface >> does not allow for this sort of optimization. > > Right, which is why this conversation is about extending that interface > :) > >> Or did I miss something? > > No, I think you're in "violent agreement". > > -- James > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended recipient, please notify the sender and delete all copies. Emails to and from our network may be logged and monitored. This email and its attachments are scanned for virus by our scanners and are believed to be safe. However, no warranty is given that this email is free of malicious content or virus. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
