Pascal Cohen <pcohen@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
