Re: order by question - Mailing list pgsql-general

From Kevin Grittner
Subject Re: order by question
Date
Msg-id 1407428118.36408.YahooMailNeo@web122301.mail.ne1.yahoo.com
Whole thread Raw
In response to order by question  (Steve Clark <sclark@netwolves.com>)
List pgsql-general
Steve Clark <sclark@netwolves.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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: order by question
Next
From: Chris Curvey
Date:
Subject: dump/restore with a hidden dependency?