REGEX character search broken

[Ruslan Zasukhin]

On 4/22/05 3:35 PM, "jda" <jda at his.com> wrote:

> Hi Ruslan,
> 
> I use REGEX to search for character strings in my db (fields are
> indexedbyword). This is broken in 2.0.3. The following search worked
> before:
> 
> select id,hit from thereferences where (keywords REGEX '(?i)*') order by id
> 
> I think it fails because now REGEX uses indexes. Can we get the old
> behavior back? Speed is not important if you can't do the search.

Well, I think FindRegEx() have second parameter, where you can say:
    NOT to use index

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]