Обсуждение: BUG #5831: Splitting string into char array with string_to_array does not work
BUG #5831: Splitting string into char array with string_to_array does not work
От
"Splitting string into char array with string_to_array"
Дата:
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: postgres=# select string_to_array('ab', '' ), regexp_split_to_array('ab', '' ); string_to_array â regexp_split_to_array ââââââââââââââââââ¼ââââââââ âââââââââââââââ {ab} â {a,b} (1 row) Why an empty string given as a separator to string_to_array is not splitting the string at all?
"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
Re: BUG #5831: Splitting string into char array with string_to_array does not work
От
Pavel Stehule
Дата:
2011/1/11 Splitting string into char array with string_to_array <valgog@gmail.com>: > > The following bug has been logged online: > > Bug reference: =C2=A0 =C2=A0 =C2=A05831 > Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Splitting string into char a= rray with string_to_array > Email address: =C2=A0 =C2=A0 =C2=A0valgog@gmail.com > PostgreSQL version: 9.0.1 > Operating system: =C2=A0 Ubuntu/Linaro 4.4.4-14ubuntu5 > Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0Splitting 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=3D# select regexp_split_to_array('abc',''); regexp_split_to_array ----------------------- {a,b,c} (1 row) Regards Pavel Stehule > > =C2=A0 =C2=A0postgres=3D# select string_to_array('ab', '' ), > regexp_split_to_array('ab', '' ); > =C2=A0 =C2=A0 string_to_array =E2=94=82 regexp_split_to_array > > =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=C3=A2 > =EF=BF=BD=EF=BF=BD=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80 > =C2=A0 =C2=A0 {ab} =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=E2=94=82 {a,= b} > =C2=A0 =C2=A0(1 row) > > Why an empty string given as a separator to string_to_array is not splitt= ing > the string at all? > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >