Re: [HACKERS] string_to_array with empty input

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark <stark(at)enterprisedb(dot)com> wrote:
>> On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason <sam(at)samason(dot)me(dot)uk> wrote:
>>> string_to_array('',',')::INT[] => invalid input syntax for integer: ""
>>
>> Oof. That's a good point.

> +1. I find this argument much more compelling than anything else
> that's been offered up so far.

Yeah. It seems to me that if you consider only the case where the array
elements are text, there's a weak preference for considering '' to be a
single empty string; but as soon as you think about any other datatype,
there's a strong preference to consider it a zero-element list. So I
too have come around to favor the latter interpretation. Do we have
any remaining holdouts?

regards, tom lane