Re: rules regression test failed on mingw

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: rules regression test failed on mingw
Date: 2008-12-15 15:19:16
Message-ID: 366.1229354356@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> What it looks like is that the locale is intentionally sorting h after k
>> (or more likely the rule is ch after ck). My Spanish is just about gone
>> ... is that a sane behavior at all?

> not at all... where can i check those rules?

Well, one thing you should try is

select 'wieck'::text < 'wiech'::text;
select 'wieck'::text > 'wiech'::text;

just to confirm whether the comparisons are actually working that way
or we've got some other issue. You could also try initdb'ing in other
locales to see if the behavior changes.

I have no idea how to poke into the internals of Windows' locale
definitions.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-12-15 15:26:53 Re: rules regression test failed on mingw
Previous Message Jaime Casanova 2008-12-15 15:15:34 Re: rules regression test failed on mingw