Thanks, Tom! I'll tackle this issue this weekend. I'll also upgrade to PostgreSQL 8 (most probably)
Thanks once again for your comprehensive reply! Best regards, Ludmil Tinkov -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 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: Ðна > --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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
