Martin Gainty wrote: <blockquote cite="mid:BLU142-W15179F226ED6BF8A1854D9AE8B0@phx.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
theoutput in certain cases. <br /><br /> I'm for not returning nulls or returning zero element array. <br /><br />
I'masking how is the other better by giving a real world example??? I don't see the plus side at the moment. <br />
