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