BUG #1069: functions "lower()" and "upper()" not characterset-aware

The following bug has been logged online:

Bug reference: 1069
Logged by: Interzone

Email address: info(at)interzone(dot)gr

PostgreSQL version: 7.4

Operating system: Linux 2.4.24

Description: functions "lower()" and "upper()" not characterset-aware

Details:

the functions "lower()" and "upper()" do not seem to work correctly with
ISO_8859_7 values

Test case:
CREATE DATABASE mediagrk WITH TEMPLATE = template0 ENCODING = 'ISO_8859_7';
CREATE TABLE test1 (
code serial NOT NULL,
compname character varying(100) NOT NULL
);
INSERT INTO test1 VALUES (1, '');
SELECT lower(compname) from test1;

if there is a problem (there might be) with the greek characters above, just
remember that this is a iso-8859-7 encoded text (and I changed the encoding
of the form-page to iso-8859-7 before sending).