| 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: | Whole Thread | Raw Message | 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 |