DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=aRUvJ1NyaRZmp0GVguOVbDqFLJDWH993DfuksaCMPVWwbnZ2gOc0NCxcd+Xln/4EkE
	gqoEvTIFyCpXzY+z4MgujUMdKFGhh0FhOgKDvRUs/e1KnCAnjG36Vb4ghW+KKiFLdEWs
	Qp6SrCbhhEswrvtAnNoGvO83+s3lw202AGbtQ=
MIME-Version: 1.0
Date: Tue, 22 Jun 2010 16:52:23 -0400
Message-ID: <AANLkTimupyTgU-h-LKkV9VprzFopMMBKqsoO2RVpAzgL@mail.gmail.com>
Subject: ORDER BY is case insensitive
From: Bryan White <nicktook@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

I was suprised to find out that ORDER BY is case insensitive.  Is
there a way to do a case sensitive ORDER BY clause?

This transcript demonstrates what I am seeing:

$ createdb bryan
$ psql bryan
psql (8.4.4)
Type "help" for help.

bryan=# create table t (f text);
CREATE TABLE
bryan=# insert into t (f) values ('a');
INSERT 0 1
bryan=# insert into t (f) values ('b');
INSERT 0 1
bryan=# insert into t (f) values ('c');
INSERT 0 1
bryan=# insert into t (f) values ('B');
INSERT 0 1
bryan=# select * from t order by f;
 f
---
 a
 b
 B
 c
(4 rows)

bryan=# \q
~  $ psql -l
                                     List of databases
      Name       |  Owner   | Encoding |  Collation  |    Ctype    |
Access privileges
-----------------+----------+----------+-------------+-------------+-----------------------
 bryan           | bryan    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres        | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0       | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                   :
postgres=CTc/postgres
 template1       | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                   :
postgres=CTc/postgres
(4 rows)


-- 
Bryan White