Re: UTF8MatchText

Поиск
Список
Период
Сортировка
От db@zigo.dhs.org
Тема Re: UTF8MatchText
Дата
Msg-id 57644.192.121.104.48.1179727084.squirrel@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: UTF8MatchText  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: UTF8MatchText  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches
> Doh, you're right ... but on third thought, what happens with a pattern
> containing "%_"?  If % tries to advance bytewise then we'll be trying to
> apply NextChar in the middle of a data character, and bad things ensue.

Right, when you have '_' after a '%' you need to make sure the '%'
advances full characters. In my suggestion the test if '_' (or '\') come
after the '%' is done once and it select which of the two loops to use,
the one that do byte stepping or the one with NextChar.

It's difficult to know for sure that we have thought about all the corner
cases. I hope the gain is worth the effort.. :-)

/Dennis

В списке pgsql-patches по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: COPY-able csv log outputs
Следующее
От: NikhilS
Дата:
Сообщение: Re: CREATE TABLE LIKE INCLUDING INDEXES support