Lists: | pgsql-bugs |
---|
From: | "Splitting string into char array with string_to_array" <valgog(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5831: Splitting string into char array with string_to_array does not work |
Date: | 2011-01-11 15:44:48 |
Message-ID: | 201101111544.p0BFimF1087272@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5831
Logged by: Splitting string into char array with string_to_array
Email address: valgog(at)gmail(dot)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?
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Splitting string into char array with string_to_array" <valgog(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5831: Splitting string into char array with string_to_array does not work |
Date: | 2011-01-11 16:16:05 |
Message-ID: | 18908.1294762565@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Splitting string into char array with string_to_array" <valgog(at)gmail(dot)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
From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Splitting string into char array with string_to_array <valgog(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5831: Splitting string into char array with string_to_array does not work |
Date: | 2011-01-11 20:01:37 |
Message-ID: | AANLkTikFOLgsA4dn3FwUDEpV-2cGs91KGxZCrsw2xHEL@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
2011/1/11 Splitting string into char array with string_to_array
<valgog(at)gmail(dot)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(at)gmail(dot)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
>
> 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?
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>