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:[EMAIL PROTECTED] |
| Sweden | http://www.devo.se |
+-----------------------------+------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
