Re: [SQL] Distinct oddity

2009-05-13 Thread Tom Lane
Glenn Maynard writes: > For purposes of DISTINCT, I'd expect any sort order should do; all it > needs is for equal values to be grouped together. If strcoll() ever > fails to do that, I'd call it a critical bug--even throwing total > garbage at it should result in a consistent ordering, even if t

Re: [SQL] Distinct oddity

2009-05-13 Thread Glenn Maynard
For purposes of DISTINCT, I'd expect any sort order should do; all it needs is for equal values to be grouped together. If strcoll() ever fails to do that, I'd call it a critical bug--even throwing total garbage at it should result in a consistent ordering, even if the ordering itself is totally m

Re: [SQL] Distinct oddity

2009-05-13 Thread Tom Lane
I wrote: > Maximilian Tyrtania writes: >> am 12.05.2009 19:23 Uhr schrieb Alvaro Herrera unter >> alvhe...@commandprompt.com: >>> What platform are you using anyway? >> Mac OS 10.4.11 > I have some vague recollection that UTF8-using locales don't actually > work well on OSX ... check the archive

Re: [SQL] Distinct oddity

2009-05-13 Thread Tom Lane
Maximilian Tyrtania writes: > am 12.05.2009 19:23 Uhr schrieb Alvaro Herrera unter > alvhe...@commandprompt.com: >> What platform are you using anyway? > Mac OS 10.4.11 I have some vague recollection that UTF8-using locales don't actually work well on OSX ... check the archives ...

Re: [SQL] Distinct oddity

2009-05-13 Thread Maximilian Tyrtania
am 09.05.2009 16:33 Uhr schrieb Tom Lane unter t...@sss.pgh.pa.us: > What you need to do is > dump out the *entire* results of the DISTINCT queries and look for the > unmatched lines. I'd try dumping to two files, stripping the 'e' with > sed, and then sort/diff. Okay, that's what I did, and the