From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | t-ishii(at)sra(dot)co(dot)jp |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Constantin Teodorescu <teo(at)flex(dot)ro>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Broken select on regular expression !!! |
Date: | 1999-05-21 04:39:55 |
Message-ID: | 199905210439.AAA19033@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 1999-05-21 05:04:23 | Re: [HACKERS] Broken select on regular expression !!! |
Previous Message | Bruce Momjian | 1999-05-21 04:08:53 | Re: [HACKERS] Broken select on regular expression !!! |