Re: like/ilike improvements
| От | Tom Lane |
|---|---|
| Тема | Re: like/ilike improvements |
| Дата | |
| Msg-id | 28377.1180056379@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: like/ilike improvements (Andrew Dunstan <andrew@dunslane.net>) |
| Ответы |
Re: like/ilike improvements
Re: like/ilike improvements |
| Список | pgsql-hackers |
Andrew Dunstan <andrew@dunslane.net> writes:
> 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?
You have to be on a first byte before you can meaningfully apply
NextChar, and you have to use NextChar or else you don't count
characters correctly (eg "__" must match 2 chars not 2 bytes).
regards, tom lane
В списке pgsql-hackers по дате отправления: