On 29 April 2010 13:35, Bård Grønbech <baard(dot)gronbech(at)gmail(dot)com> wrote:
> Have a string like '0.1;0.2;null;0.3' which I would like to convert
> into a double precision[] array.
>
> Trying:
>
> select cast (string_to_array('0.1;0.2;null;0.3', ';') as float8[])
>
> gives me an error: invalid input syntax for type double precision: "null".
>
> Can anybody help me?
>
> -Bård
>
>
I believe string_to_array will take that null as a string called 'null',
which it can't convert to a float8.
Regards
Thom