On 3/15/19 12:26 PM, Pavel Stehule wrote: > you use string_to_array function without separator, then only one possible > semantic is there - separation by chars.
Other languages can and do specify other semantics for the separator-omitted case: often (as in Python) it means to split around "runs of one or more characters the platform considers white space", as a convenience, given that it's a fairly commonly wanted meaning but can be tedious to spell out as an explicit separator.
for this proposal "char" != byte
result[n] = substring(str FROM n FOR 1)
I admit I think a separator of '' would be more clear than null, so if I were designing string_to_array in a green field, I think I would swap the meanings of null and '' as the delimiter: null would mean "don't really split anything", and '' would mean "split everywhere you can find '' in the string", that is, everywhere.
But the current behavior is already established....