On Wed, 08 Apr 2015 11:36:01 +0200 Chris Mair <ch...@1006.org> wrote:
> PostreSQL relies on the OS's C lib. So this kind > of ordering problems depend on the OS' idea about > collations. > > I don't know what's the rationale behin this, > but it looks like Linux ignores the . when doing the sort. Not only '.'. Sorting by VARCHAR is not ASCII order, but "alphabetical" (whatever it means), which causes some behaviour to be more real-life oriented than logically coherent, like this one: select * from ejemplo order by texto; id | texto ----+---------- 2 | Lalin 1 | La Palma 3 | Lasarte It is pretty obvious that ' ' is not between 'l' and 's', but this makes more sense than 1 | La Palma 2 | Lalin 3 | Lasarte -- Alberto Cabello Sánchez <albe...@unex.es> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
