BUG #8352: Using UPPER in ON clause of JOIN

The following bug has been logged on the website:

Bug reference: 8352
Logged by: Daisy
Email address: dyuen(at)rbauction(dot)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))