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 |
+-----------------------------+------------------------------+
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 |