Sort order with spaces? - Mailing list pgsql-sql

From Kristian Jörg
Subject Sort order with spaces?
Date
Msg-id 3F682DB3.6080905@devo.se
Whole thread Raw
Responses Re: Sort order with spaces?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Hello!

I am having troubles with sort order in Postgres. It seems that space is 
not handled at all?
For instance the following rows are sorted in MS SQL Server as:

LUNDGREN
M L R
MACDOWELL
MUSCLE

But in Postgres I get this order:

LUNDGREN
MACDOWELL
M L R
MUSCLE

I seems that space is no considered at all so "M L R" is interpreted as 
"MLR" i Postgres. This is a problem for me taht I need to resolve. How 
do I do that?

Regards
Kristian

--           \\|//          (@ @)
+------ooO--(_)--Ooo----------+------------------------------+
| Kristian Jörg               | Phone: +46 54 153395         |
| Devo IT AB                  | Fax:   +46 54 153389         |
| Box 533, SE-651 12 KARLSTAD | mailto:kristian.jorg@devo.se |
| Sweden                      | http://www.devo.se           |
+-----------------------------+------------------------------+



pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: Re: sub query
Next
From: "Martin Kuria"
Date:
Subject: Re: sub query