Re: BUG #1996: DISTINCT fails with national character varying

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ludmil Tinkov" <ludmil(at)fyrex(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1996: DISTINCT fails with national character varying
Date: 2005-10-25 02:33:38
Message-ID: 8528.1130207618@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Ludmil Tinkov" <ludmil(at)fyrex(dot)com> 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 postmaster's LC_CTYPE locale
setting. It's really a bug in the locale definitions, if you ask me,
but good luck getting the glibc guys to change those :-(. In the
meantime, make sure your locale and encoding agree.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Klint Gore 2005-10-25 02:48:10 Re: BUG #1993: Adding/subtracting negative time intervals
Previous Message Bruce Momjian 2005-10-24 23:12:11 Re: BUG #1985: cannot insert Chinese character into a table encoded