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 even if > it's the same, there are often platform-specific interpretations of > the sorting rules. (Not to mention that OS X is flat out broken when > it comes to sorting UTF8 data ...) > > I just ran these: linux: on linux # SELECT CASE WHEN 'apache' > '!yada' THEN 'TRUE' ELSE 'FALSE' END FROM pg_user; case ------- FALSE (1 row) # show lc_collate; lc_collate ------------- en_US.UTF-8 (1 row) ------------------------ on mac os x: # SELECT CASE WHEN 'apache' > '!yada' THEN 'TRUE' ELSE 'FALSE' END FROM pg_user; case ------ TRUE (1 row) # show lc_collate; lc_collate ------------- en_US.UTF-8 (1 row) ----------------------- Why is the linux postgres saying false with the lc_collage set the way it is? -wes
