<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Martin Gainty wrote:
<blockquote cite="mid:BLU142-W15179F226ED6BF8A1854D9AE8B0(at)phx(dot)gbl"
type="cite">
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
<tt class="LITERAL">Split strings into array elements using provided
delimiter<br>
<br>
string_to_array('xx~^~yy~^~zz', '~^~') <br>
output: </tt><tt class="LITERAL">{xx,yy,zz}</tt><br>
<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.3/interactive/functions-array.html">http://www.postgresql.org/docs/8.3/interactive/functions-array.html</a><br>
<br>
</blockquote>
Sorry thats not the question i'm asking. <br>
<br>
We are debating if it makes sense to change the output in certain
cases. <br>
<br>
I'm for not returning nulls or returning zero element array. <br>
<br>
I'm asking how is the other better by giving a real world example??? I
don't see the plus side at the moment. <br>
</body>
</html>