I don't like LIKE

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема I don't like LIKE
Дата
Msg-id 375D203D.6EE932EC@alumni.caltech.edu
обсуждение исходный текст
Ответы Re: [HACKERS] I don't like LIKE  (Oleg Bartunov <oleg@sai.msu.su>)
Re: [HACKERS] I don't like LIKE  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] I don't like LIKE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
There seems to be a problem with MakeIndexable(), though I haven't
confirmed that the problem lies there:

postgres=> select * from t1 where i like '2';
ERROR:  pg_atoi: error in "2ÿ": can't parse "ÿ"

istm that this query should behave itself, or at least fail in some
other way :(

I'll guess that, even though there isn't a wildcard to pattern match,
MakeIndexable() is adding a trailing \377 to the string?
               - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


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

Предыдущее
От: Dmitry Samersoff
Дата:
Сообщение: Re: [HACKERS] Priorities for 6.6
Следующее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] 6.6 items