On Mon, Dec 15, 2008 at 11:27 AM, Tom Lane <tgl@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