Ordering a name list and ignoring whitespace

From: Mikel Lindsaar <raasdnil(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Ordering a name list and ignoring whitespace
Date: 2009-04-16 10:51:37
Message-ID: 57a815bf0904160351v7282fd00p7b7d9690ca48dcff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2009-04-16 11:02:44 Re: Ordering a name list and ignoring whitespace
Previous Message Andreas Joseph Krogh 2009-04-16 10:21:01 Re: Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps