Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nKKxv-0003bg-8M
	for pgsql-docs@arkaria.postgresql.org; Wed, 16 Feb 2022 14:07:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1nKKxt-0000qz-KK
	for pgsql-docs@arkaria.postgresql.org; Wed, 16 Feb 2022 14:07:29 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <peter.eisentraut@enterprisedb.com>)
	id 1nKKxt-0000qq-05
	for pgsql-docs@lists.postgresql.org; Wed, 16 Feb 2022 14:07:29 +0000
Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <peter.eisentraut@enterprisedb.com>)
	id 1nKKxl-0007aR-NY
	for pgsql-docs@lists.postgresql.org; Wed, 16 Feb 2022 14:07:27 +0000
Received: by mail-lf1-x129.google.com with SMTP id f37so4028765lfv.8
        for <pgsql-docs@lists.postgresql.org>;
 Wed, 16 Feb 2022 06:07:21 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=enterprisedb.com; s=google;
        h=mime-version:references:in-reply-to:from:date:message-id:subject:to
         :cc;
        bh=k9QVjJ/BdDRwiHujO+aPn4gadyTnNuQOiamNBBpOhCA=;
        b=INJzBBVTHZoIwwIqmvYd+o5kzGyYvv7OWMwyuAGAqwrxYbrZIeo1FCmfEPqqKVRbOp
         qBb6XvIUl+og8Q23NEHH6ptYnIJXC9qd8O8oGhsPkrGHgyLQVhNPfkGn5hPDHGs0ZkbU
         MAipSRgGPZ+fsLDW4xF23Ym8mVn3IblItzQZX8p1i2jsZXcmdAMt7SnaQjHrasLHuKic
         VD9KejOJJV82bT7IBmw6qMZ/euuHSoHo/FRjrtqCRXqT7WgRCasDBBZq60Kpzo69fVVy
         gQQi3qY+aEUFkvnb9ZVNQwTNxXnCJ7I3GTUqvkevgv95xvusWKg0U9GifMtBtNHGMpOx
         snmA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=k9QVjJ/BdDRwiHujO+aPn4gadyTnNuQOiamNBBpOhCA=;
        b=eZMkJNTJTaCnB/SW2tlhBB1eGeA2cIPhu2+kf8nYXspX+Zapb8/eUYxFUyLJdeDLxu
         NDdCph44/yjY/UXw+Pv+s6wjYKkKXIMH+1H/NIl8yCgAJIof7dZ2KM5MnXsx3k+ibkXF
         n9/Vr5iUfRwXaWkeVzmJZWJ53WiTHNE2OZs60K5ceRkpKzZn+Tw5cIFBpH7rptvFyKoU
         +5MKzZqZqtXLJTbueUDgml4vbw+c9DXPl+fJywzDes7kFkuSDyiGlEYvdor6P7Ww2hRl
         H1D2ATPFdE7B0pS3gEv6lUg6Lq+kxss7PB4TyhabiU7Fi0/Xp7W0ZtWT+myRm0WYqWUq
         Havg==
X-Gm-Message-State: AOAM531/AOqAehsTvrdOrBT2BDRESNrxBeQ5HGV28iDNf2Lq4nlEmobX
	13fzFTaHz003Hqf9K/jvrvHYPid305sfVmfsPpSAbCkqjbNhqzKlKpuU2oCuu0JIOuUYUAZjUon
	9isIMbMbKy+pAj8crhsAHrqLr/PjIPzIVikNrC9/L71R/7WYpRRbTcepneNYElpkDprV5VFZZfN
	9cuM6r4KpK1VHMmKDq5bwXD2kUO3I8llQVH/4LXsbanssAmlJz6YNXpYLzW65S
X-Google-Smtp-Source: 
 ABdhPJzfhdZiqyVW29Wnur5BHlAPlj33SjnaLLNupJ9z9qsxVFOeT0LBHDFXtmTz1x7t8QFHCwedR+QOfb54gn6Y12g=
X-Received: by 2002:a05:6512:714:b0:443:3d6e:db1a with SMTP id
 b20-20020a056512071400b004433d6edb1amr2159074lfs.596.1645020439824; Wed, 16
 Feb 2022 06:07:19 -0800 (PST)
MIME-Version: 1.0
References: <164494187300.23318.373331246819207718@wrigleys.postgresql.org>
 <08bff51d-eb6b-381f-ca6b-08234828c754@enterprisedb.com>
 <ead8dcb5-e1c0-174f-c609-61843f9fa1de@univ-cotedazur.fr>
In-Reply-To: <ead8dcb5-e1c0-174f-c609-61843f9fa1de@univ-cotedazur.fr>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Date: Wed, 16 Feb 2022 15:07:08 +0100
Message-ID: 
 <CA+3yvDOTyxkUUyTk-KqOH_RE9gxC-hjYPndPZRJwjxSBHod23g@mail.gmail.com>
Subject: Re: Does the POSITION() function takes into account the COLLATION...
 or not ?!?
To: =?UTF-8?Q?Pierre=2DAur=C3=A9lien_GEORGES?=
 <Pierre-Aurelien.GEORGES@univ-cotedazur.fr>
Cc: pageorge@unice.fr, pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f6e79905d8232ad7"
X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor
X-CLOUD-SEC-AV-Sent: true
X-Gm-Spam: 0
X-Gm-Phishy: 0
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2B3yvDOTyxkUUyTk-KqOH_RE9gxC-hjYPndPZRJwjxSBHod23g%40mail.gmail.com>
Precedence: bulk

--000000000000f6e79905d8232ad7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Feb 16, 2022 at 12:01 PM Pierre-Aur=C3=A9lien GEORGES <
Pierre-Aurelien.GEORGES@univ-cotedazur.fr> wrote:

> ok, let's take it forwards, then :-)
>
> Can someone provide some examples where a supported deterministic
> collation is having an impact on the result of a call to function
> POSITION() ?
>

There are no such cases currently.

--000000000000f6e79905d8232ad7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Feb 16, 2022 at 12:01 PM Pierre-A=
ur=C3=A9lien GEORGES &lt;<a href=3D"mailto:Pierre-Aurelien.GEORGES@univ-cot=
edazur.fr">Pierre-Aurelien.GEORGES@univ-cotedazur.fr</a>&gt; wrote:<br></di=
v><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex">ok, let&#39;s take it forwards, then :-)<br>
<br>
Can someone provide some examples where a supported deterministic <br>
collation is having an impact on the result of a call to function <br>
POSITION() ?<br></blockquote><div><br></div><div>There are no such cases cu=
rrently.</div></div></div>

--000000000000f6e79905d8232ad7--