Re: order by question

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Steve Clark <sclark(at)netwolves(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: order by question
Date: 2014-08-07 16:15:18
Message-ID: 1407428118.36408.YahooMailNeo@web122301.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Steve Clark <sclark(at)netwolves(dot)com> wrote:

> It is like the space character and the - in -Letter is ignored.

Yes, that is how the en_US collation is defined.  I think the goal
is to make it something like "phone book" ordering.  If you still
have a "white pages" book around, look at how a business name with
a hyphen (or a hyphenated last name) is sorted there.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Clark 2014-08-07 16:42:36 Re: order by question
Previous Message Adrian Klaver 2014-08-07 16:10:46 Re: order by question