BUG #5831: Splitting string into char array with string_to_array does not work

"Splitting string into char array with string_to_array" <valgog@gmail.com> writes:

I cannot really remember now for sure, but the splitting string into array
using an empty string ('') worked for me on pre-9.0 versions to get array of
string chars.

Really? I get this in all versions since 7.4, where string_to_array was
introduced:

regression=# select string_to_array('ab', '' );
string_to_array
-----------------
{ab}
(1 row)

regards, tom lane

2011/1/11 Splitting string into char array with string_to_array
<valgog@gmail.com>:

The following bug has been logged online:

Bug reference:      5831
Logged by:          Splitting string into char array with string_to_array
Email address:      valgog@gmail.com
PostgreSQL version: 9.0.1
Operating system:   Ubuntu/Linaro 4.4.4-14ubuntu5
Description:        Splitting string into char array with string_to_array
does not work
Details:

Hi,

I cannot really remember now for sure, but the splitting string into array
using an empty string ('') worked for me on pre-9.0 versions to get array of
string chars. Now I have the following behavior:

Hello

it's newer worked like you remember

postgres=# select regexp_split_to_array('abc','');
regexp_split_to_array
-----------------------
{a,b,c}
(1 row)

Regards

Pavel Stehule