Re: [BUGS] BUG #1996: DISTINCT fails with national character varying

2005-10-26 Thread Ludmil Tinkov
5:34 AM To: Ludmil Tinkov Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #1996: DISTINCT fails with national character varying "Ludmil Tinkov" <[EMAIL PROTECTED]> writes: > select distinct name from depression > --the last statement returns only a single row > --namely:

Re: [BUGS] BUG #1996: DISTINCT fails with national character varying

2005-10-24 Thread Tom Lane
"Ludmil Tinkov" <[EMAIL PROTECTED]> writes: > select distinct name from depression > --the last statement returns only a single row > --namely: Ана > --it should return 4 rows! This has been seen to happen when you select a database encoding that does not match the encoding expected by the pos

[BUGS] BUG #1996: DISTINCT fails with national character varying

2005-10-24 Thread Ludmil Tinkov
The following bug has been logged online: Bug reference: 1996 Logged by: Ludmil Tinkov Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.2 Operating system: RedHat 9.0 Description:DISTINCT fails with national character varying Details: create table depression