>>>>> "David" == David G Johnston <david.g.johnston@gmail.com> writes:
>> There are two tables with the type of column is char. when Using a
>> 'like' predicate in a join condition will result in an incorrect
>> result. Because there is no 'like' operator that left operand and
>> right operand are all bpchar.(bpchar ~~ bpchar), final the operator
>> 'bpchar ~~ text' will be found form candidate set. so database do
>> the cast from bpchar to text, The space at the end of the string was
>> removed during the cast.
David> A similar complaint was made the other day; Tom's response
David> succinctly sums up the prevailing opinion as to the character
David> type.
It's also listed as WONTFIX here:
https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard#Trailing_spaces_in_character.28n.29
though I guess adding the LIKE case as an example there might be good.
--
Andrew (irc:RhodiumToad)
