Re: rules regression test failed on mingw - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: rules regression test failed on mingw
Date
Msg-id 3073cc9b0812150828h713bb2e5ha6c2df9cedd6300d@mail.gmail.com
Whole thread Raw
In response to Re: rules regression test failed on mingw  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: rules regression test failed on mingw
Next
From: Tom Lane
Date:
Subject: Re: Block-level CRC checks