The following bug has been logged on the website: Bug reference: 8352 Logged by: Daisy Email address: dy...@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)) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
