On Mon, Dec 15, 2008 at 11:27 AM, Tom Lane t...@sss.pgh.pa.us 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
Jaime Casanova jcasa...@systemguards.com.ec 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
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Jaime Casanova jcasa...@systemguards.com.ec 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
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us 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
On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane t...@sss.pgh.pa.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
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 10:12 AM, Tom Lane t...@sss.pgh.pa.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
Tom Lane wrote:
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us 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
On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Tom Lane wrote:
Jaime Casanova jcasa...@systemguards.com.ec writes:
On Mon, Dec 15, 2008 at 8:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
What locale is this running in?
Seems this is Spanish_Spain.1252 and
Jaime Casanova wrote:
On Mon, Dec 15, 2008 at 10:26 AM, Alvaro Herrera
alvhe...@commandprompt.com 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
Alvaro Herrera alvhe...@commandprompt.com 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
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 why
On Mon, Dec 15, 2008 at 10:19 AM, Tom Lane t...@sss.pgh.pa.us 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
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
--
13 matches
Mail list logo