Hello
I have one idea, that should simplify string to char array
transformation. The base is idea: between every char is empty string,
so empty string is regular separator for string_to_array function.
This behave is inversion of array_to_string function behave:
postgres=# select array_to_string(array['a','b','c'],'');array_to_string
-----------------abc
(1 row)
postgres=# select string_to_array('abc','');string_to_array
----------------- {a,b,c}
(1 row)
Notes, ideas???
Regards
Pavel Stehule