Re: [BUGS] BUG #4338: Order by seems to trim some characters before sort

2008-08-02 Thread Tom Lane
"Domingo Alvarez Duarte" <[EMAIL PROTECTED]> writes: > It seems that postgresql is issuing a kind of trim on the column value > before sort/compare, because it's ignoring spaces and '-' wich I use > propositally to move some values to front. > Why postgresql is behaving this way ? Because the LC_

[BUGS] BUG #4338: Order by seems to trim some characters before sort

2008-08-02 Thread Domingo Alvarez Duarte
The following bug has been logged online: Bug reference: 4338 Logged by: Domingo Alvarez Duarte Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.9 Operating system: linux Description:Order by seems to trim some characters before sort Details: I have a test t