On Mon, Dec 15, 2008 at 10:19 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Well, one thing you should try is
>
> select 'wieck'::text < 'wiech'::text;
> select 'wieck'::text > 'wiech'::text;
>
Administrador@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@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