From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: "zengman@halodbtech.com" <zengman@halodbtech.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: =?UTF-8?Q?Re:_BUG_#18632:_Whether_you_need_to_consider_modifying_?=
         =?UTF-8?Q?the_array's_handling_of_delimiters=EF=BC=9F?=
In-reply-to: 
 <CAKFQuwb2F8Pnw8+Ftb=5zerGGO7sG2-p=cVGsY9=p3ZWVXxmVA@mail.gmail.com>
References: <18632-15cedd7d4154ea2a@postgresql.org>
 <CAKFQuwb2F8Pnw8+Ftb=5zerGGO7sG2-p=cVGsY9=p3ZWVXxmVA@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Wed, 25 Sep 2024 05:33:15 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3647704.1727275884.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Wed, 25 Sep 2024 10:51:24 -0400
Message-ID: <3647705.1727275884@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3647705.1727275884%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Wednesday, September 25, 2024, PG Bug reporting form <
> noreply@postgresql.org> wrote:
>> So should we consider modifying "array_in" to enhance the handling of
>> separators to be more consistent with people's expectations?

> A design being inflexible or not meeting people’s expectations is not a
> bug.  The system is behaving as documented.  And we are not going to be
> redefining how valid code is parsed here.

Yeah, I seriously doubt that we could change array_in's behavior
for single quotes (to wit, that they are not special in any way)
without breaking existing applications.

			regards, tom lane