Robert Haas <robertmhaas@xxxxxxxxx> writes:
> On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark <stark@xxxxxxxxxxxxxxxx> wrote:
>> On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason <sam@xxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
