Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 6DE4F63542F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri,  8 May 2009 14:36:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 93090-02-7 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri,  8 May 2009 14:36:17 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f163.google.com (mail-gx0-f163.google.com
	[209.85.217.163])
	by mail.postgresql.org (Postfix) with ESMTP id 416E7635180
	for <pgsql-sql@postgresql.org>; Fri,  8 May 2009 14:26:53 -0300 (ADT)
Received: by gxk7 with SMTP id 7so2220120gxk.19
	for <pgsql-sql@postgresql.org>; Fri, 08 May 2009 10:26:40 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type:content-transfer-encoding;
	bh=IMwBgTrF4tY1tT7I86WVKo6d+GpnA+cXDSVFJFzKwjs=;
	b=TYNO7qRflbV0cM4OiCr5e5eOxZygO6Hji9AlK06bV1BM0JSZ9vmnd4JfjGcFkVlHjG
	QZbVkzJfhSyrLL5fMXjEMeVe3YRCIiZznv73xJX7er6gj7Alq5JzPvyvblpBReNGu2hP
	SSxBoMUPmX2lkt5sArrARC0qkTlbEz0UxJDtI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type
	:content-transfer-encoding;
	b=gTrVjEh1TVvZq3AAv4K2VKSbsQyFcwLpZN7FZe4wd1Pzp8h6G0qBBWibiOzvTpCogA
	X8C/77cRUReZRrPKExFj990Iu+09MmWzzwSML6sbB40fRmETAHf8sgQ5lGxuvZZ9xXnz
	kF58x+/ni2XRjS4R5cvVYRbYxmWjw/wkkYEVw=
MIME-Version: 1.0
Received: by 10.90.79.4 with SMTP id c4mr2924252agb.118.1241803586122;
 Fri, 08
	May 2009 10:26:26 -0700 (PDT)
Date: Fri, 8 May 2009 12:26:25 -0500
Message-ID: <4544e0330905081026u36b29014i43f1fc85d048916f@mail.gmail.com>
Subject: ascii-betical sort order?
From: Peter Koczan <pjkoczan@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200905/33
X-Sequence-Number: 32525

Is there some way to do ascii-betical sort ordering in postgres (i.e.
capital letters come before lowercase)? It appears that text ordering
is dictionary-alphabetical. It's useful, but it's different from the
DBMS I'm porting some applications from (SQL Server, in case you were
curious).

It may not be terribly important, but it'd be useful to know in case
it actually is an issue.

I couldn't find any clear answer searching online.

Thanks,
Peter