On Apr 1, 2009, at 10:05 AM, justin wrote:
> string_to_array('',',')::INT[] works as proposed
>
> But
> string_to_array(',,,', ',' )::INT[] Fails
> or
> string_to_array('1,2,,4', ',' )::INT[] Fails .
>
>
> I'm trying to understand the difference between a empty string to a
> string with many blank entries between the delimiter.
> Consider ',,,,,,' = '' once the delimiter is removed . Yet
> Seven zero length entries were passed. How is that going to be
> handled????
Right, it's making a special case of '', which does seem rather
inconsistent to me.
Best,
David