| From: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
|---|---|
| To: | kleptog(at)svana(dot)org |
| Cc: | gsstark(at)MIT(dot)EDU (Greg Stark), tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane), johnseberg(at)yahoo(dot)com (John Seberg), pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Duplicate Values or Not?! |
| Date: | 2005-09-17 17:45:17 |
| Message-ID: | 200509171745.j8HHjIfI025171@gw.tssi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2005-09-17 18:14:08 | Re: Duplicate Values or Not?! |
| Previous Message | Martijn van Oosterhout | 2005-09-17 17:13:50 | Re: Duplicate Values or Not?! |