On Mon, Dec 15, 2008 at 11:27 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > I wrote: >> But I don't see this sorting behavior with glibc on Linux (Fedora 9 to >> be exact, testing LC_COLLATE=es_ES.utf8). >
doh! i'm seeing this again in HEAD (and in 8.3.5) when executing make installcheck on openSuse 11 when initdb'ing i get this, that i think is right 'cause i was using --locale=es_EC.UTF8: The database cluster will be initialized with locale es_EC.UTF8. The default database encoding has accordingly been set to UTF8. The default text search configuration will be set to "spanish". then i can confirm that in psql: postgres=# show LC_COLLATE; lc_collate ------------ es_EC.UTF8 (1 row) nevertheless i get (and of course failed regression tests): postgres=# select 'wieck'::text < 'wiech'::text; ?column? ---------- t (1 row) postgres=# select 'wieck'::text > 'wiech'::text; ?column? ---------- f (1 row) even worse, seems like the ordering is case insensitive in both 8.3.5 and HEAD, is this intended? regression=# select 'S1' union all select 's1' regression-# union all regression-# select 'S2' union all select 's2' regression-# order by 1; ?column? ---------- s1 S1 s2 S2 (4 rows) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
regression.diffs
Description: Binary data
version
-----------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-linux-gnu, compiled by GCC gcc (SUSE Linux)
4.3.1 20080507 (prerelease) [gcc-4_3-branch revision 135036]
(1 row)
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
