Re: [SQL] order by different on mac vs linux

2012-05-31 Thread Peter Eisentraut
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 standa

Re: [SQL] order by different on mac vs linux

2012-05-31 Thread Wes James
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: > Wes James 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 a

Re: [SQL] order by different on mac vs linux

2012-05-26 Thread Jasen Betts
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

Re: [SQL] order by different on mac vs linux

2012-05-26 Thread Wes James
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

Re: [SQL] order by different on mac vs linux

2012-05-26 Thread Wes James
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

Re: [SQL] order by different on mac vs linux

2012-05-16 Thread Scott Marlowe
On Wed, May 16, 2012 at 7:58 PM, Wes James wrote: > > > On Wed, May 16, 2012 at 5:00 PM, Samuel Gendler > wrote: >> >> >> >> On Wed, May 16, 2012 at 3:46 PM, Wes James wrote: >>> >>> >>> >>> On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: Wes James writes: > Why is there a diff

Re: [SQL] order by different on mac vs linux

2012-05-16 Thread Wes James
On Wed, May 16, 2012 at 5:00 PM, Samuel Gendler wrote: > > > On Wed, May 16, 2012 at 3:46 PM, Wes James wrote: > >> >> >> On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: >> >>> Wes James writes: >>> > Why is there a different order on the different platforms. >>> >>> This is not exactly unusua

Re: [SQL] order by different on mac vs linux

2012-05-16 Thread Samuel Gendler
On Wed, May 16, 2012 at 3:46 PM, Wes James wrote: > > > On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: > >> Wes James 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 i

Re: [SQL] order by different on mac vs linux

2012-05-16 Thread Wes James
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: > Wes James 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 a

Re: [SQL] order by different on mac vs linux

2012-05-15 Thread Wes James
On Tue, May 15, 2012 at 10:16 AM, Scott Marlowe wrote: > On Tue, May 15, 2012 at 10:06 AM, Wes James wrote: >> On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: >>> Wes James writes: Why is there a different order on the different platforms. >>> >>> This is not exactly unusual.  You should

Re: [SQL] order by different on mac vs linux

2012-05-15 Thread Scott Marlowe
On Tue, May 15, 2012 at 10:06 AM, Wes James wrote: > On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: >> Wes James 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 t

Re: [SQL] order by different on mac vs linux

2012-05-15 Thread Wes James
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: > Wes James 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

Re: [SQL] order by different on mac vs linux

2012-05-15 Thread Wes James
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: > Wes James 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

Re: [SQL] order by different on mac vs linux

2012-05-15 Thread Wes James
On Mon, May 14, 2012 at 5:00 PM, Tom Lane wrote: > Wes James 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

Re: [SQL] order by different on mac vs linux

2012-05-14 Thread Tom Lane
Wes James 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 of the sorting rule

[SQL] order by different on mac vs linux

2012-05-14 Thread Wes James
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 dif