Re: LIKE, CHAR(), and trailing spaces
| От | Brendan Jurd |
|---|---|
| Тема | Re: LIKE, CHAR(), and trailing spaces |
| Дата | |
| Msg-id | AANLkTikB9nbesPX7q-UDYNTQEU8qi3KGE=qzPMHRYRu+@mail.gmail.com обсуждение исходный текст |
| Ответ на | LIKE, CHAR(), and trailing spaces (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: LIKE, CHAR(), and trailing spaces
|
| Список | pgsql-hackers |
On 3 February 2011 10:54, Bruce Momjian <bruce@momjian.us> wrote: > It seems LIKE is considering the trailing CHAR(10) field spaces as > significant, even though our documentations says: > -- snip -- > > It says trailing spaces are not significant for character comparisons > --- the real question is whether LIKE is a comparison. Obvioiusly '=' > is a comparison, but the system does not treat LIKE as a comparison in > terms of trailing spaces. Is that desired behavior? Interesting. I would have to say that from the user point of view, LIKE is definitely a comparison, and if the rest of the operators on bpchar ignore whitespace then LIKE ought to as well. Is the situation the same for regex matches (~ operators)? Cheers, BJ
В списке pgsql-hackers по дате отправления: