Re: Duplicate Values or Not?!

Поиск
Список
Период
Сортировка
Искать
От
Mike Nolan
Тема
Re: Duplicate Values or Not?!
Дата
Msg-id
200509171745.j8HHjIfI025171@gw.tssi.com
Ответ на
Re: Duplicate Values or Not?! (Martijn van Oosterhout)
Список
Дерево обсуждения
Duplicate Values or Not?! John Seberg <johnseberg@yahoo.com>
Re: Duplicate Values or Not?! Greg Stark <gsstark@mit.edu>
Re: Duplicate Values or Not?! Tom Lane <tgl@sss.pgh.pa.us>
Re: Duplicate Values or Not?! Greg Stark <gsstark@mit.edu>
Re: Duplicate Values or Not?! Greg Stark <gsstark@mit.edu>
Re: Duplicate Values or Not?! Martijn van Oosterhout <kleptog@svana.org>
Re: Duplicate Values or Not?! Mike Nolan <nolan@gw.tssi.com>
Re: Duplicate Values or Not?! Martijn van Oosterhout <kleptog@svana.org>
Re: Duplicate Values or Not?! Greg Stark <gsstark@mit.edu>
Re: Duplicate Values or Not?! Martijn van Oosterhout <kleptog@svana.org>
Re: Duplicate Values or Not?! Tom Lane <tgl@sss.pgh.pa.us>
> I don't know if it's guarenteed by spec, but it certainly seems silly
> for strings to compare equal when they're not. Just because a locale
> sorts ignoring case doesn't mean that "sun" and "Sun" are the same. The
> only real sensible rule is that strcoll should return 0 only if strcmp
> would also return zero...

I disagree.  Someone who wants true case independence (for whatever reason)
needs all aspects of uniqueness such as selects, indexes and groups
treating data the same way.  

This needs to be something the person who creates the instance or the 
database can control.
--
Mike Nolan
В списке pgsql-general по дате отправления
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Duplicate Values or Not?!
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Duplicate Values or Not?!
FAQ