BUG #1996: DISTINCT fails with national character varying - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1996
Logged by:          Ludmil Tinkov
Email address:      ludmil@fyrex.com
PostgreSQL version: 7.3.2
Operating system:   RedHat 9.0
Description:        DISTINCT fails with national character varying
Details:

create table depression(ID int, name national character varying(50))

insert into depression values(1, 'Ана');
insert into depression values(2, 'Ива');
insert into depression values(3, 'Ина');
insert into depression values(4, 'Яна');

select distinct name from depression

--the last statement returns only a single row
--namely: Ана
--it should return 4 rows!