Re: BUG #18632: Whether you need to consider modifying the array's handling of delimiters?

Wolfgang Walther <walther@technowledgy.de>

From: Wolfgang Walther <walther@technowledgy.de>
To: 曾满 <zengman@halodbtech.com>, Erik Wienhold <ewie@ewie.name>, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2024-09-25T10:13:44Z
Lists: pgsql-bugs
曾满:
> I wonder if we need to modify array_in so that ''a,3'' and ''a-3'' 
> behave the same and have a uniform style.

You are still using single quotes, but two of them. You need to use 
**double** quotes, not two single quotes.

''a,3'' is different from "a,3".

With true double quotes:

postgres=# SELECT unnest('{"a-3","a,3"}'::varchar[]);
  unnest
--------
  a-3
  a,3
(2 rows)

Best,

Wolfgang