Re: string_to_array, array_to_string function without separator

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: string_to_array, array_to_string function without separator
Дата
Msg-id CAFj8pRDHnXNBjmapC=LAmiW1kVnN0teoXhqbVUfCRkUxmKNp_g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: string_to_array, array_to_string function without separator  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: string_to_array, array_to_string function without separator
Список pgsql-hackers


pá 15. 3. 2019 v 17:16 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
Chapman Flack <chap@anastigmatix.net> writes:
> So the proposal seems roughly equivalent to making string_to_array's
> second parameter optional default null, and array_to_string's second
> parameter optional default ''.

In that case why bother?  It'll just create a cross-version compatibility
hazard for next-to-no keystroke savings.  If the cases were so common
that they could be argued to be sane "default" behavior, I might feel
differently --- but if you were asked in a vacuum what the default
delimiters ought to be, I don't think you'd say "no delimiter".

My motivation is following - sometimes I need to convert string to array of chars. Using NULL as separator is possible, but it is not intuitive. When you use string_to_array function without separator, then only one possible semantic is there - separation by chars.

I understand so there is a possible collision and possible meaning of missing parameter like default value. But in this case this meaning, semantic is not practical.

Regards

Pavel


                        regards, tom lane

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

Предыдущее
От: emmjadea
Дата:
Сообщение: Inquiries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: GTIN14 support for contrib/isn