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

From: Wolfgang Walther <walther(at)technowledgy(dot)de>
To: 曾满 <zengman(at)halodbtech(dot)com>, Erik Wienhold <ewie(at)ewie(dot)name>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18632: Whether you need to consider modifying the array's handling of delimiters?
Date: 2024-09-25 10:13:44
Message-ID: 5de58d33-5623-4d8c-8b83-af2b61d52e91@technowledgy.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tender Wang 2024-09-25 10:19:20 Re: BUG #18630: Incorrect memory access inside ReindexIsProcessingIndex() on VACUUM
Previous Message Tender Wang 2024-09-25 09:28:42 Re: BUG #18630: Incorrect memory access inside ReindexIsProcessingIndex() on VACUUM