Sort order with spaces?
От | Kristian Jörg |
---|---|
Тема | Sort order with spaces? |
Дата | |
Msg-id | 3F682DB3.6080905@devo.se обсуждение исходный текст |
Ответы |
Re: Sort order with spaces?
|
Список | 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 по дате отправления: