Re: Distinct oddity

Maximilian Tyrtania wrote:
> am 08.05.2009 16:55 Uhr schrieb Rob Sargent unter robsargent@rocketmail.com:

> > and what locale are you running in?
> 
>  lc_collate                      | de_DE
> | Shows the collation order locale.
>  lc_ctype                        | de_DE
> | Shows the character classification and case conversion locale.
> 
> The encoding is UTF-8.

Note that the de_DE locale uses Latin9 encoding, which is incompatible
with UTF8.  I'd try checking if the problem is reproducible in
de_DE.utf8 (you need to create a new database for testing, obviously).
If it's not, then the incompatible locale definition is causing the
problem.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support