James Gates <james(dot)gates(at)sun(dot)com> writes:
> I'm working with a issue where it seems the PostgreSQL server collation
> sequence for certain locales don't match the operating system's
> collation sequence for the same locale (set during initdb).
> I can reproduce this on both 8.1.9 & 8.2.5 on Solaris (both Nevada & 10).
FWIW, your example works as expected for me with 8.3 CVS tip on Fedora
postgres=# show lc_collate ;
postgres=# select barf,ascii(barf) from jim order by barf asc;
barf | ascii
a | 97
A | 65
> In fact, I can't tell where this order is derived from?
In this context Postgres believes whatever strcoll() tells it. I don't
see any obvious hole in your methodology (except that I'm dubious about
the exhibited arguments for sort(1)) so it seems possible you've got a
bug in Solaris' strcoll(). But you should probably triple-check the
question of whether what's arriving at strcoll() is in the encoding it
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2007-10-30 05:02:25|
|Subject: Re: SSL Connectivity on Solaris 10 x86 |
|Previous:||From: Scott Marlowe||Date: 2007-10-30 04:18:04|
|Subject: Re: Raid Chunk Sizes for DSS type DB|