Re: [GENERAL] sorting and spaces in postgresql with en_US locale

2004-07-21 Thread Oliver Elphick
On Wed, 2004-07-21 at 20:58, Chris Kratz wrote: > We are having a weird problem that we ran into recently. If I use the > following statements to create a test table and then run the select statement > at the end, we get a very strange sort order. It appears that to do the > sorting, all the s

[GENERAL] sorting and spaces in postgresql with en_US locale

2004-07-21 Thread Chris Kratz
We are having a weird problem that we ran into recently. If I use the following statements to create a test table and then run the select statement at the end, we get a very strange sort order. It appears that to do the sorting, all the spaces are removed from the strings. It would appear that