Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: LIKE, CHAR(), and trailing spaces
On 3 February 2011 10:54, Bruce Momjian <bruce(at)momjian(dot)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
In response to
- LIKE, CHAR(), and trailing spaces at 2011-02-02 23:54:42 from Bruce Momjian
Responses
- Re: LIKE, CHAR(), and trailing spaces at 2011-02-03 00:48:38 from Bruce Momjian
pgsql-hackers by date
Next: From: Bruce Momjian Date: 2011-02-03 00:48:38 Subject: Re: LIKE, CHAR(), and trailing spaces Previous: From: Justin Pitts Date: 2011-02-03 00:29:20 Subject: Re: [HACKERS] Slow count(*) again...