order by text-type : whitespaces ignored??
От | peter pilsl |
---|---|
Тема | order by text-type : whitespaces ignored?? |
Дата | |
Msg-id | 457FB733.2070602@goldfisch.at обсуждение исходный текст |
Ответы |
Re: order by text-type : whitespaces ignored??
|
Список | pgsql-general |
I just get my mind crossed here: I do a simple select with order on a text-type. In my opinion entries with leading spaces should be either first (or maybe last) in the list. But in my select the whitespace just seems to be ignored: Note that the second row has a leading space and should imho be first entry. # select traeger from wb_traeger where id>24 order by traeger; traeger ----------------------------------------- GliA - gehirn | lern | impuls | agentur Sonstige Träger Volkshochschule Floridsdorf Zukunftszentrum Tirol (4 rows) note that this not only applies to leading spaces: # select 'x'||traeger from wb_traeger where id>24 order by 'x'||traeger; ?column? ------------------------------------------ xGliA - gehirn | lern | impuls | agentur x Sonstige Träger xVolkshochschule Floridsdorf xZukunftszentrum Tirol (4 rows) the type of my column is simple text: # \d wb_akademie Table "public.wb_akademie" Column | Type | Modifiers -------------+-----------------------------+---------------------------------------------------- <skip> traeger | text | <skip> Is there any way to order so that entries with leading spaces are listed first?? thnx, peter
В списке pgsql-general по дате отправления: