Re: rules regression test failed on mingw

On Mon, Dec 15, 2008 at 10:19 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Well, one thing you should try is
>
> select 'wieck'::text < 'wiech'::text;
> select 'wieck'::text > 'wiech'::text;
>

Administrador(at)casanova10 ~/pg.build/8.4dev
$ bin/psql -a -f test.sql postgres
select 'wieck'::text < 'wiech'::text;
?column?
----------
t
(1 row)

select 'wiech'::text < 'wieck'::text;
?column?
----------
f
(1 row)

> just to confirm whether the comparisons are actually working that way
> or we've got some other issue.

ok, confirmed...

> You could also try initdb'ing in other
> locales to see if the behavior changes.
>

Actually, using Spanish_Ecuador.1252 (wich is the one a i should use
from the beginning anyway ;) gives correct results, maybe the other
behaviour is correct in spain... we have a lot of spanish languages ;)

Administrador(at)casanova10 ~/pg.build/8.4dev
$ bin/psql -a -f test.sql postgres
select 'wieck'::text < 'wiech'::text;
?column?
----------
f
(1 row)

select 'wiech'::text < 'wieck'::text;
?column?
----------
t
(1 row)

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157