| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | andrew(at)supernews(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: like/ilike improvements |
| Date: | 2007-05-24 23:32:19 |
| Message-ID: | 46562083.1080309@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Tom Lane wrote:
> There should somewhere be a block comment explaining all the reasoning
> we've so painfully gone through about why the three cases (SB, MB, UTF8)
> are needed and how they must differ.
>
>
>
I'm working on a detailed description/rationale.
However, I have just about convinced myself that we don't need
IsFirstByte for matching "_" for UTF8, either preceded by "%" or not, as
it should always be true. Can anyone come up with a counter example? I
don't mind keeping it and using it in Assert() though.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2007-05-25 00:02:06 | Re: Reviewing temp_tablespaces GUC patch |
| Previous Message | Alvaro Herrera | 2007-05-24 23:18:44 | Re: Reviewing temp_tablespaces GUC patch |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-05-25 00:45:40 | Rewritten Index Advisor patch |
| Previous Message | Tom Lane | 2007-05-24 21:09:04 | Re: Configure template change to use SysV Semaphors on darwin |