From: | justin <justin(at)emproshunts(dot)com> |
---|---|
To: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] string_to_array with empty input |
Date: | 2009-03-31 16:48:54 |
Message-ID: | 49D24976.5040300@emproshunts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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[]
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2009-03-31 17:06:03 | Re: string_to_array with empty input |
Previous Message | Harald Fuchs | 2009-03-31 16:41:42 | Re: [GENEAL] dynamically changing table |
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira de Oliveira | 2009-03-31 16:55:02 | Re: can't load plpython |
Previous Message | Emmanuel Cecchet | 2009-03-31 16:45:17 | Re: Partitioning feature ... |