Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 5C8C4634092
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 16 Apr 2009 07:51:40 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 54703-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 16 Apr 2009 07:51:38 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-gx0-f220.google.com (mail-gx0-f220.google.com
	[209.85.217.220])
	by mail.postgresql.org (Postfix) with ESMTP id 68B10633ED8
	for <pgsql-sql@postgresql.org>; Thu, 16 Apr 2009 07:51:38 -0300 (ADT)
Received: by gxk20 with SMTP id 20so1084009gxk.19
	for <pgsql-sql@postgresql.org>; Thu, 16 Apr 2009 03:51:37 -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=zm4HATx4tvMR2FjuPWqzcHeAwFl9fWjyKITyiQGZTuI=;
	b=i/pFrrSisv+/6+DLQHNRfHZcmAJfgvC0ZV3JXgt97ku4qIOkyiMzhTVM30tb6KYQYu
	UNi508LVMKVvxYz07TbIBX2PyVl7eJJDBmIbu3FkcAMLPUBPzxeHsAZPMX7X2CMQBzOP
	ChWF/V+nAK/GBve27JJvT4HCL2FnECPMCJQes=
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=Owv1TKzTeijRzY7392uHPMYBVAhokPiCbOPZyWrlqnbEkwr1NBrZQlHQ6rjLFNn9An
	HXQt7SWzVWfvhAcpVABwJk5kimwnC+FwR5gTGpj4DpNrLp5quDQBREDx2bhV37SmU4FY
	djgeioR5l+XzkrNPaTb7AQnHOlRkTxWrkaMYk=
MIME-Version: 1.0
Received: by 10.150.225.14 with SMTP id x14mr1797371ybg.150.1239879097066;
	Thu, 16 Apr 2009 03:51:37 -0700 (PDT)
Date: Thu, 16 Apr 2009 20:51:37 +1000
Message-ID: <57a815bf0904160351v7282fd00p7b7d9690ca48dcff@mail.gmail.com>
Subject: Ordering a name list and ignoring whitespace
From: Mikel Lindsaar <raasdnil@gmail.com>
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
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: 200904/86
X-Sequence-Number: 32432

Hi all,

Doing some googling and looking through the docs, I can't find an
obvious way to do this beside post processing after the query (which I
am trying to avoid).

I'm trying to select a list of names in alphabetical order but
ignoring the whitespace.

So for example, the name "La Combe" should come after "Lace" but
before "Lacs..."


Any ideas?

Mikel