[BUGS] BUG #3737: lower/upper fails to match extended chars in LATIN1

[Jonas Forsman]

The following bug has been logged online:

Bug reference:      3737
Logged by:          Jonas Forsman
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.1.10
Operating system:   Ubuntu 6.06 LTS
Description:        lower/upper fails to match extended chars in  LATIN1
Details: 

Try:
select * from table where lower(address) like '%Ã¥%'

This select fails to find addresses including capital Å and similars in
LATIN1 (like Å, Ä, Ö). 

The same bug is valid for upper.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend