On 08/02/2013 01:48 AM, dy...@rbauction.com wrote: > 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))
I am unable to reproduce this. Can you provide a self-contained example please? Vik -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
