SQL Error [0A000]: ERROR: nondeterministic collations are notsupported for LIKE

Поиск
Список
Период
Сортировка
От Jeff Lanzarotta
Тема SQL Error [0A000]: ERROR: nondeterministic collations are notsupported for LIKE
Дата
Msg-id CACykOPQ+JvBwHLA_TZi6=V0+y+_CgGtb8i9zfLFkOexwsGpexA@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения
Hello,

I have a question about nondeterministic collations.  I have created a new collation that is  nondeterministic and created several columns which use this collation.  Querying these columns works great until I use LIKE.  When I do, I get the following error:

SQL Error [0A000]: ERROR: nondeterministic collations are not supported for LIKE

Is there any plan to allow this functionality?

Thanks,

В списке pgsql-general по дате отправления:

Предыдущее
От: Stan Brown
Дата:
Сообщение: Re: A question about sequences and backup/restore cycles
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Primary key definition?