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

From Ludmil Tinkov
Subject BUG #1996: DISTINCT fails with national character varying
Date
Msg-id 20051024212213.3802BF1141@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1996: DISTINCT fails with national character varying
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!

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1985: cannot insert Chinese character into a table encoded
Next
From: Tom Lane
Date:
Subject: Re: BUG #1996: DISTINCT fails with national character varying