On 3 February 2011 10:54, Bruce Momjian <br...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
