Re: [HACKERS] Broken select on regular expression !!! - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Broken select on regular expression !!!
Date
Msg-id 199905210439.AAA19033@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Broken select on regular expression !!!  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] Broken select on regular expression !!!
List pgsql-hackers
> These all oddness are caused by the parser (makeIndexable). When
> makeIndexable sees ~* '^41|^des' , it tries to rewrite the target
> regexp so that an index can be used. The rewritten query might be
> something like:
> 
> fld1 ~* '^41|^des' and fld1 >= '41|^' and fld1 <= '41|^\377'

I have just applied a fix to gram.y that should fix this case.  Please
let me know how it works at your site.  Thanks.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Broken select on regular expression !!!
Next
From: Tatsuo Ishii
Date:
Subject: Re: [HACKERS] Broken select on regular expression !!!