Re: Duplicate Values or Not?! - Mailing list pgsql-general

From Mike Nolan
Subject Re: Duplicate Values or Not?!
Date
Msg-id 200509171745.j8HHjIfI025171@gw.tssi.com
Whole thread Raw
In response to Re: Duplicate Values or Not?!  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Duplicate Values or Not?!
List pgsql-general
> 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Duplicate Values or Not?!
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Duplicate Values or Not?!