Re: [GENERAL] string_to_array with empty input

[justin <justin(at)emproshunts(dot)com>]

Sam Mason wrote:
>   string_to_array('',',')::INT[]  => invalid input syntax for integer: ""
>
> Which you don't get at the moment; although you do currently get it in
> other common cases such as:
>
>   string_to_array('1,',',')::INT[]
>
> If you want backwards compatible behaviour you could always bung a
> NULLIF in there:
>
>   string_to_array(NULLIF('',''),',')::INT[]  => NULL
>
>
>   

But consider  this fails also

select string_to_array('1, , 3', ',' )::int[] => ERROR:  invalid input 
syntax for integer: " "

yet this works

select string_to_array('1, 2, 3',',')::int[]