Re: Dynamic collation support

On Tue, Jan 19, 2016 at 9:42 AM, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Tue, Jan 19, 2016 at 9:15 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
>> Different collates requires different plans - so using dynamic SQL is much
>> more correct.
>>
>> It is same like using variables as columns or tablenames.
>
> Right -- I get it, and I understand the planner issues.   But the
> amount of revision that goes into a database that internationalizes
> can be pretty large.  To do it right, any static sql that involves
> string ordering can't be used.  pl/sql also can't be used.  ISTM this
> is impolite to certain coding styles.

Hm, an extension wrapper to strxrm() might do the trick when
flexibility is favored over performance.  You'd have to constantly
mange the locale to make it work though.

merlin