On Mon, Dec 15, 2008 at 11:27 AM, Tom Lane wrote:
> I wrote:
>> But I don't see this sorting behavior with glibc on Linux (Fedora 9 to
>> be exact, testing LC_COLLATE=es_ES.utf8).
>
doh! i'm seeing this again in HEAD (and in 8.3.5) when executing make
installcheck on openSuse 11
when initdb'ing
On Mon, Dec 15, 2008 at 10:19 AM, Tom Lane wrote:
>
> Well, one thing you should try is
>
>select 'wieck'::text < 'wiech'::text;
>select 'wieck'::text > 'wiech'::text;
>
administra...@casanova10 ~/pg.build/8.4dev
$ bin/psql -a -f test.sql postgres
select 'wieck'::text < 'wiech'::t
I wrote:
> But I don't see this sorting behavior with glibc on Linux (Fedora 9 to
> be exact, testing LC_COLLATE=es_ES.utf8).
BTW, I *do* see wieck < wiech in es_ES locale on HPUX 10.20, released
~1996. So I think we have correctly identified the core issue, and the
only interesting question is w
Alvaro Herrera writes:
> Jaime Casanova wrote:
>> while 'ch' and 'll' are independent letters they sort as they were 'c'
>> and 'l'... that means that 'ch' should go before 'ck'
> Interesting. So they are both wrong, glibc and teachers. We can file a
> bug with glibc but I'm not sure we can do
Jaime Casanova wrote:
> On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera
> wrote:
> > It was sane behavior a couple of decades ago -- dictionaries used to
> > sort like this ("ch" was considered an independent letter, and sorted
> > between c and d).
>
> while 'ch' and 'll' are independent lette
On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera
wrote:
> Tom Lane wrote:
>> "Jaime Casanova" writes:
>> > On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane wrote:
>> >> What locale is this running in?
>>
>> > Seems this is Spanish_Spain.1252 and the encoding WIN1252
>>
>> What it looks like is that the
Tom Lane wrote:
> "Jaime Casanova" writes:
> > On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane wrote:
> >> What locale is this running in?
>
> > Seems this is Spanish_Spain.1252 and the encoding WIN1252
>
> What it looks like is that the locale is intentionally sorting h after k
> (or more likely the
"Jaime Casanova" writes:
> On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane 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
On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane 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?
--
Atenta
"Jaime Casanova" writes:
> On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane wrote:
>> What locale is this running in?
> Seems this is Spanish_Spain.1252 and the encoding WIN1252
What it looks like is that the locale is intentionally sorting h after k
(or more likely the rule is ch after ck). My Spani
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane wrote:
> "Jaime Casanova" writes:
>> i'm seeing a fail in the rules regression, seems like it is not
>> ordering the results right even when the regression has an explicit
>> order by...
>
> What locale is this running in?
>
Seems this is Spanish_Spain.1
"Jaime Casanova" writes:
> i'm seeing a fail in the rules regression, seems like it is not
> ordering the results right even when the regression has an explicit
> order by...
What locale is this running in?
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql
Hi,
i'm seeing a fail in the rules regression, seems like it is not
ordering the results right even when the regression has an explicit
order by...
i'm in a mingw32 5.1 on xp sp2 using msys 1.0.10 and gcc 3.4.2
attached the regression.diffs
please make me know if i can provide more info
--
Ate
13 matches
Mail list logo
