Obscure behavior of ORDER BY

Поиск
Список
Период
Сортировка
Искать
От
Tambet Matiisen
Тема
Obscure behavior of ORDER BY
Дата
Msg-id
4D871A6E.6050608@gmail.com
Список
Дерево обсуждения
Obscure behavior of ORDER BY Tambet Matiisen <tambet.matiisen@gmail.com>
Re: Obscure behavior of ORDER BY Pavel Stehule <pavel.stehule@gmail.com>
Hi everyone!

I recently noticed obscure behavior of ORDER BY. Consider this example:

select email from
(
select '@'::text as email
union all
select '.'::text as email
) a
order by email;

The result is: email
------- . @
(2 rows)

This is all normal - I expect, that dot is smaller than ampersand. But 
if I add anything after dot, the order is reversed:

select email from
(
select '@'::text as email
union all
select '.m'::text as email
) a
order by email

The result is: email
------- @ .m
(2 rows)

Why is this happening? As dot is smaller than ampersand, anything after 
dot shouldn't matter.

I'm using PostgreSQL 8.4.7 on 32-bit Debian.

Thanks in advance,  Tambet

В списке pgsql-sql по дате отправления
От: Serdar Gül
Дата:
Сообщение: Re: xml2 support
От: Rob Sargent
Дата:
Сообщение: xml2 support
FAQ