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

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

Not sure if my original email was actually received or not.  If it was, forgive the repost...

I have a question about nondeterministic collations in PostgreSQL 12.  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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Having more than one constraint trigger on a table
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Having more than one constraint trigger on a table