Re: [HACKERS] Broken select on regular expression !!!

Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> Something is rotten in the state of Denmark...

> These all oddness are caused by the parser (makeIndexable).

Ah-hah, I'm sure you're right.  That makes *two* serious bugs in
makeIndexable.  (We still don't have an adequate solution
for its known problem in non-C locales...)

> It seems that the only solution is checking '|' to see if it appears
> in the target regexp and giving up the optimization in that case.

I'm feeling a strong urge to just rip out makeIndexable until
it can be redesigned... how many other problems has it got
that we haven't stumbled upon?
        regards, tom lane