Re: Does the POSITION() function takes into account the COLLATION... or not ?!?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Does the POSITION() function takes into account the COLLATION... or not ?!?
Дата
Msg-id 08bff51d-eb6b-381f-ca6b-08234828c754@enterprisedb.com
обсуждение исходный текст
Ответ на Does the POSITION() function takes into account the COLLATION... or not ?!?  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: Does the POSITION() function takes into account the COLLATION... or not ?!?  (Pierre-Aurélien GEORGES <Pierre-Aurelien.GEORGES@univ-cotedazur.fr>)
Список pgsql-docs
Дерево обсуждения 
On 15.02.22 17:17, PG Doc comments form wrote:
> Does the POSITION() function pretends taking into account the COLLATION ??
> or not ??
> 
> - If not, then why the hell is there this error message about
> nondeterministic collations while the POSITION() doesn't care at all about
> the COLLATION...
> - If yes, then the first 6 lines of SQL above are returning the wrong
> value... (are there any specific technical limitations here ?)

I think you have that backwards.  Your examples would only succeed if 
POSITION() supported nondeterministic collations, but it doesn't.

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

Предыдущее
От: Jian He
Дата:
Сообщение: Re: Data Type Size Calculation
Следующее
От: Pierre-Aurélien GEORGES
Дата:
Сообщение: Re: Does the POSITION() function takes into account the COLLATION... or not ?!?