From: Greg Stark <gsstark@mit.edu>
To: Rob Sargent <robjsargent@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Odd sort behaviour
Date: Wed, 2 Sep 2009 00:04:54 +0100
Message-ID: <407d949e0909011604t4613ac5eue8bd8fa65e72abfb@mail.gmail.com> (raw)
In-Reply-To: <4A9DA0DD.7010606@gmail.com>
References: <4A9D8BC4.30906@gmail.com>
<dcc563d10909011438x784d3309pfe00e779002ff1af@mail.gmail.com>
<4A9DA0DD.7010606@gmail.com>
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
--
greg
http://mit.edu/~gsstark/resume.pdf
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: gsstark@mit.edu, robjsargent@gmail.com, scott.marlowe@gmail.com
Subject: Re: Odd sort behaviour
In-Reply-To: <407d949e0909011604t4613ac5eue8bd8fa65e72abfb@mail.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