MIME-Version: 1.0
References: <CACJufxHTBkymh06D4mGKNe1YfRNFN+gFBybmygWk=PtMqu00LQ@mail.gmail.com>
 <CAKFQuwYD477A9Oy2PxRr_KY8t=k=jbOUK83ie0dS7fcpBsXS3Q@mail.gmail.com>
 <CACJufxE9kt7fAz_g_6PO0PmxK=duWDx+dNUyEWHkGxmRw0EqOg@mail.gmail.com>
 <CAKFQuwZ=ZEkQaFZBRpukNn-qvk4U52ZAsrLLRPAC4hgcZsJmkQ@mail.gmail.com>
 <CACJufxFpzqdfYvsj2iWhtemRyPSB5O7_gb9vRd7cE1ZcVvmZnw@mail.gmail.com>
 <CAKFQuwa-j+oA23EVA7qk+AUdpi24d1LC_O9MH5oSnzOv2McEhg@mail.gmail.com>
 <CACJufxH0jqshH6SC97eQ7T=QcSYpbtKMR2=wmds=K2UT9t0tFw@mail.gmail.com>
 <CAKFQuwbPdo1MORJqnQj=eA6bGrvGu_U+8J+oTWw7QDvuX2oAQw@mail.gmail.com>
 <CACJufxGF6vU7KUMqHL0RehdvwVBENz2Q++ZyGJaCzk2_VVPqWQ@mail.gmail.com> <CAKFQuwZU=eY0F6jE4ekuPs5FMqNr2e-mJ=MTuaZTeDG+Xti1=g@mail.gmail.com>
In-Reply-To: <CAKFQuwZU=eY0F6jE4ekuPs5FMqNr2e-mJ=MTuaZTeDG+Xti1=g@mail.gmail.com>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Tue, 1 Apr 2025 10:14:58 -0300
Message-ID: <CAB-JLwathhELcwARpTJ5cAh-Z6tS6V8PCXti9woGZMJiqzCPfA@mail.gmail.com>
Subject: Re: add function argument name to substring and substr
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: jian he <jian.universality@gmail.com>, 
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000018961f0631b75561"
Archived-At: <https://www.postgresql.org/message-id/CAB-JLwathhELcwARpTJ5cAh-Z6tS6V8PCXti9woGZMJiqzCPfA%40mail.gmail.com>
Precedence: bulk

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

Em ter., 1 de abr. de 2025 =C3=A0s 02:00, David G. Johnston <
david.g.johnston@gmail.com> escreveu:

Wouldn't it be good to add the use of parentheses using posix ? It's useful
and rarely documented
        <literal>substring('Thomas', '...$')</literal>
+        <literal>substring('Email: johnjohn@mymail.com, Name: John' from
'@(.*), Name')</literal>

regards
Marcos

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

<div dir=3D"ltr"><div dir=3D"ltr">Em ter., 1 de abr. de 2025 =C3=A0s 02:00,=
 David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.=
g.johnston@gmail.com</a>&gt; escreveu:</div><div class=3D"gmail_quote gmail=
_quote_container"><div><br></div><div class=3D"gmail_default" style=3D"font=
-family:verdana,sans-serif;color:rgb(102,102,102)">Wouldn&#39;t it be good =
to add the use of parentheses using posix ? It&#39;s useful and rarely docu=
mented</div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-=
serif;color:rgb(102,102,102)">=C2=A0 =C2=A0 =C2=A0 =C2=A0 &lt;literal&gt;su=
bstring(&#39;Thomas&#39;, &#39;...$&#39;)&lt;/literal&gt;</div><div class=
=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,10=
2,102)">+ =C2=A0 =C2=A0 =C2=A0 =C2=A0&lt;literal&gt;substring(&#39;Email: <=
a href=3D"mailto:johnjohn@mymail.com">johnjohn@mymail.com</a>, Name: John&#=
39; from &#39;@(.*), Name&#39;)&lt;/literal&gt;</div><div><div class=3D"gma=
il_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"=
><br></div></div><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif;color:rgb(102,102,102)">regards</div><div class=3D"gmail_default=
" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">Marcos</d=
iv></div></div>

--00000000000018961f0631b75561--