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

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: pageorge(at)unice(dot)fr, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Does the POSITION() function takes into account the COLLATION... or not ?!?
Date: 2022-02-16 10:56:17
Message-ID: 08bff51d-eb6b-381f-ca6b-08234828c754@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Pierre-Aurélien GEORGES 2022-02-16 11:01:18 Re: Does the POSITION() function takes into account the COLLATION... or not ?!?
Previous Message Jian He 2022-02-16 04:24:12 Re: Data Type Size Calculation