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 по дате отправления