>> C locale and en_* locales give different ordering (at least under Linux).
>> The en_* ordering is case insensitive, and the C locale ordering is case
>> sensitive because it is simply comparing the ASCII codes.
>
> You could use lower/upper to get case insensitive ordering with C locale.
Okay, that's great, so I'm going to re-initialise my database cluster with
the C locale this week-end.
I'll report the results, for the record.
Thanks to everyone who replied!
Kind regards
Harry Mantheakis
London, UK
---------------------------(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
