Re: Dynamic collation support
От | Merlin Moncure |
---|---|
Тема | Re: Dynamic collation support |
Дата | |
Msg-id | CAHyXU0xy8zqvrYiADYTtyO_NMwi=iUcmZ=a67=NCAy+wa+SpTA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Dynamic collation support (Merlin Moncure <mmoncure@gmail.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: