Re: rules regression test failed on mingw

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