From: Rob Sargent <robjsargent@gmail.com>
To: Greg Stark <gsstark@mit.edu>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Odd sort behaviour
Date: Tue, 01 Sep 2009 17:22:45 -0600
Message-ID: <4A9DACC5.3040504@gmail.com> (raw)
In-Reply-To: <407d949e0909011604t4613ac5eue8bd8fa65e72abfb@mail.gmail.com>
References: <4A9D8BC4.30906@gmail.com>
<dcc563d10909011438x784d3309pfe00e779002ff1af@mail.gmail.com>
<4A9DA0DD.7010606@gmail.com>
<407d949e0909011604t4613ac5eue8bd8fa65e72abfb@mail.gmail.com>
OK, I'm waking up now. My locale is as Scott suspected, en-US.UTF-8,
and of
course my server too.
I guess I never really left "C" intellectually :) and we have a server that
thinks SQL-ASCII is cool and comparing lists of names and emails between
that server
and my local utf-8 one was rather perplexing.
I'm sure this a life-time's worth of discussion on the merits of
treating "."
as nothing when sorting....
Sorry for the noise.
Greg Stark wrote:
> On Tue, Sep 1, 2009 at 11:31 PM, Rob Sargent<robjsargent@gmail.com> wrote:
>
>> How many ways might one accidentally do that I wonder.
>>
>
> Well most operating system distributions ask you when you install them
> what region you're in and use a collation for that region.
>
> In 8.4 you can check what collation a database is set to use with \l
> in psql. In 8.3 the entire "cluster" has a single collation which you
> can see using "show lc_collate".
>
> You can see how your system's collations work by running sort:
>
> $ LC_ALL=c sort s
> a.ecke70@gmx.de
> a.fischedick@t-online.de
> adrianohazim@hotmail.com
> adx008@show.org.tw
> aecheniq@mac.com
> aelefant@unina.it
> aeo_tw@hotmail.com
> aflores3432@gmail.com
> afried@advancedneurosurgeons.com
> agave007@comcast.net
> agelsinger@amirsys.com
> agis1doc@yahoo.gr
>
> $ LC_ALL=en_US sort s
> adrianohazim@hotmail.com
> adx008@show.org.tw
> aecheniq@mac.com
> a.ecke70@gmx.de
> aelefant@unina.it
> aeo_tw@hotmail.com
> a.fischedick@t-online.de
> aflores3432@gmail.com
> afried@advancedneurosurgeons.com
> agave007@comcast.net
> agelsinger@amirsys.com
> agis1doc@yahoo.gr
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, gsstark@mit.edu, scott.marlowe@gmail.com
Subject: Re: Odd sort behaviour
In-Reply-To: <4A9DACC5.3040504@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox