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, so

[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

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 (both