Martin Gainty wrote:
Split strings into array elements using provided delimiter

string_to_array('xx~^~yy~^~zz', '~^~')
output:
{xx,yy,zz}

http://www.postgresql.org/docs/8.3/interactive/functions-array.html

Sorry thats not the question i'm asking. 

We are debating if it makes sense to change the output in certain cases. 

I'm for not returning nulls or returning zero element array. 

I'm asking how is the other better by giving a real world example???  I don't see the plus side at the moment.