Re: [HACKERS] string_to_array with empty input - Mailing list pgsql-general

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