On lör, 2012-05-26 at 21:47 -0600, Wes James wrote:
on the ascii table here:
http://www.ascii-code.com/
upper case letters should sort before lowercase letters.
ASCII has nothing to do with how letters should be sorted. It is not
a sorting standard, it is a character encoding standard.
On 2012-05-27, Wes James compte...@gmail.com 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
On Mon, May 14, 2012 at 4:42 PM, Wes James compte...@gmail.com 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
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
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but
On Wed, May 16, 2012 at 3:46 PM, Wes James compte...@gmail.com wrote:
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check
On Wed, May 16, 2012 at 5:00 PM, Samuel Gendler
sgend...@ideasculptor.comwrote:
On Wed, May 16, 2012 at 3:46 PM, Wes James compte...@gmail.com wrote:
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order
On Wed, May 16, 2012 at 7:58 PM, Wes James compte...@gmail.com wrote:
On Wed, May 16, 2012 at 5:00 PM, Samuel Gendler sgend...@ideasculptor.com
wrote:
On Wed, May 16, 2012 at 3:46 PM, Wes James compte...@gmail.com wrote:
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but
On Tue, May 15, 2012 at 10:06 AM, Wes James compte...@gmail.com wrote:
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to
On Tue, May 15, 2012 at 10:16 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, May 15, 2012 at 10:06 AM, Wes James compte...@gmail.com wrote:
On Mon, May 14, 2012 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Wes James compte...@gmail.com writes:
Why is there a different order on the
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 repo):
\--\
then
! *`-=[];',./~@#$%^()_+{}|:?\
Why is there a different
Wes James compte...@gmail.com writes:
Why is there a different order on the different platforms.
This is not exactly unusual. You should first check to see if
lc_collate is set differently in the two installations --- but even if
it's the same, there are often platform-specific interpretations
15 matches
Mail list logo