Prev: [HACKERS] Upcoming back-branch updates
Next: [HACKERS] On a somewhat disappointing correspondence (was: max_standby_delay considered harmful)
From: Pavel Stehule on 5 May 2010 14:42
Hello

attached patch contains to_string and to_array functions. These
functions are equivalent of array_to_string and string_to_array
function with maybe more correct NULL handling.

postgres=# select to_array('1,2,3,4,,6',',');
to_array
------------------
{1,2,3,4,NULL,6}
(1 row)

postgres=# select to_array('1,2,3,4,,6',',','***');
to_array
----------------
{1,2,3,4,"",6}
(1 row)

postgres=# select to_string(array[1,2,3,4,NULL,6],',');
to_string
------------
1,2,3,4,,6
(1 row)

postgres=# select to_string(array[1,2,3,4,NULL,6],',','***');
to_string
---------------
1,2,3,4,***,6
(1 row)

Regards
Pavel Stehule
 | 
Pages: 1
Prev: [HACKERS] Upcoming back-branch updates
Next: [HACKERS] On a somewhat disappointing correspondence (was: max_standby_delay considered harmful)