From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: rules regression test failed on mingw |
Date: | 2008-12-15 16:28:20 |
Message-ID: | 3073cc9b0812150828h713bb2e5ha6c2df9cedd6300d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-12-15 16:29:52 | Re: Block-level CRC checks |
Previous Message | Tom Lane | 2008-12-15 16:27:07 | Re: rules regression test failed on mingw |