Sort order with spaces?

From: Kristian Jörg <krjg(at)devo(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: Sort order with spaces?
Date: 2003-09-17 09:47:31
Message-ID: 3F682DB3.6080905@devo.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)jorg(at)devo(dot)se |
| Sweden | http://www.devo.se |
+-----------------------------+------------------------------+

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Kuria 2003-09-17 09:57:26 Re: sub query
Previous Message Christoph Haller 2003-09-17 08:54:49 Re: sub query