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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: t-ishii(at)sra(dot)co(dot)jp
Cc: 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 03:19:50
Message-ID: 4292.927256790@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-05-21 03:21:50 Re: [HACKERS] Broken select on regular expression !!!
Previous Message Bruce Momjian 1999-05-21 03:19:22 Re: [HACKERS] Current TODO list