Re: string_to_array with an empty input string - Mailing list pgsql-hackers

On Aug 11, 2010, at 9:40 AM, Robert Haas wrote:

> Yeah, I think David's examples are talking about the behavior of join,
> but we're trying to decide what split should do.  

Right, sorry about that.

> I think the main
> argument for making it return NULL is that you can then fairly easily
> use COALESCE() to get whatever you want.  That's a bit more difficult
> if you use return any other value.  But I think your argument that an
> empty array is better than a one-element array containing an empty
> string is very much correct, as between those options.

I prefer an empty array.

Best,

David