On Mon, May 14, 2012 at 4:42 PM, Wes James wrote:
> I have postgresql 9.1.3 on a mac and on linux.
>
> On the mac the results come out:
>
> ! *`-=[];',./~@#$%^&()_+{}|:"<>?\
>
> then
>
> \--\
>
> On ubuntu 12.04 x64 it comes out (compiled and installed postgres from
> tbz2 from postgresql.org rep
Back to the drawing board. Windows sorts these lines thus (postgresql
9.1.3):
! *`-=[];',./~@#$%^&()_+{}|:"<>?\
!!
!a
!A
!B
!ia
!test
\--\
African agricultural research and technological development
on the ascii table here:
http://www.ascii-code.com/
upper case letters should sort before lower
On 2012-05-27, Wes James wrote:
>>
>> Why is there a different order on the different platforms.
postgres uses the text comparison operators provided by the host
platform. for linux these are defined in the locales package
this may be part of the glibc package.
> I'd like to bring up my questi
