Re: Mac ordering with locales - Mailing list pgsql-general

From Tom Lane
Subject Re: Mac ordering with locales
Date
Msg-id 11708.1203613304@sss.pgh.pa.us
Whole thread Raw
In response to Mac ordering with locales  (Pascal Cohen <pcohen@wimba.com>)
Responses Re: Mac ordering with locales  ("A.M." <agentm@themactionfaction.com>)
Re: Mac ordering with locales  (Jeff Davis <pgsql@j-davis.com>)
Re: Mac ordering with locales  ("David Blewett" <david@dawninglight.net>)
List pgsql-general
Pascal Cohen <pcohen@wimba.com> writes:
> The fact is that works on Linux and win but under Mac I always get the
> ordering with 'default' C locale (I displayed all the lc_* and all are
> right set)

Yeah, this has been complained of before, eg here
http://archives.postgresql.org/pgsql-general/2005-11/msg00047.php
and here
http://archives.postgresql.org/pgsql-general/2004-04/msg00564.php

It seems to be a deficiency in Apple's locale support.  The second
message is interesting since it indicates that "smart" sorting is
available somewhere/somehow under OS X, but nobody here knows how
to get at it :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: Disable Triggers
Next
From: Tom Lane
Date:
Subject: Re: No pgxs.mk with win32 binaries