From: Kristian Jörg <krjg@devo.se>
To: pgsql-sql@postgresql.org
Subject: Sort order with spaces?
Date: Wed, 17 Sep 2003 11:47:31 +0200
Message-ID: <3F682DB3.6080905@devo.se> (raw)
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 |
+-----------------------------+------------------------------+
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: krjg@devo.se
Subject: Re: Sort order with spaces?
In-Reply-To: <3F682DB3.6080905@devo.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox