BUG #8352: Using UPPER in ON clause of JOIN - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      8352
Logged by:          Daisy
Email address:      dyuen@rbauction.com
PostgreSQL version: 9.2.4
Operating system:   Windows 7
Description:

When joining two tables on a varchar column wrapped in a upper statement,
the join does not work if there is a trailing space in both of the varchar
values.


In the two examples below, VALUE1 and VALUE2 = "ABC "


-- Doesn't work


SELECT * FROM TABLE1 INNER JOIN TABLE2 ON UPPER(VALUE1) = UPPER(VALUE2)


-- Works


SELECT * FROM TABLE1 INNER JOIN TABLE2 ON UPPER(TRIM(VALUE1)) =
UPPER(TRIM(VALUE2))