Re: [GENERAL] Collation sequence and use of operatings system's locale

2007-10-30 Thread Peter Eisentraut
Am Montag, 29. Oktober 2007 schrieb James Gates: > Notice that the results don't match the operating system's (either byte > code or dictionary) sort order for the same locale, or even the C or > POSIX locales. Note that none of the sort orders you showed match an actual Swedish dictionary sort,

Re: [GENERAL] Collation sequence and use of operatings system's locale

2007-10-29 Thread Tom Lane
James Gates <[EMAIL PROTECTED]> writes: > I'm working with a issue where it seems the PostgreSQL server collation > sequence for certain locales don't match the operating system's > collation sequence for the same locale (set during initdb). > I can reproduce this on both 8.1.9 & 8.2.5 on Solaris

[GENERAL] Collation sequence and use of operatings system's locale

2007-10-29 Thread James Gates
I'm working with a issue where it seems the PostgreSQL server collation sequence for certain locales don't match the operating system's collation sequence for the same locale (set during initdb). I can reproduce this on both 8.1.9 & 8.2.5 on Solaris (both Nevada & 10). 1) First I have a text