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

Поиск
Список
Период
Сортировка
От Wolfgang Walther
Тема Re: BUG #18632: Whether you need to consider modifying the array's handling of delimiters?
Дата
Msg-id 5de58d33-5623-4d8c-8b83-af2b61d52e91@technowledgy.de
обсуждение исходный текст
Ответ на Re: Re: BUG #18632: Whether you need to consider modifying the array's handling of delimiters?  ("曾满" <zengman@halodbtech.com>)
Список 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



В списке pgsql-bugs по дате отправления: