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