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 |
Thread: | |
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 | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-01-11 16:16:05 | Re: BUG #5831: Splitting string into char array with string_to_array does not work |
Previous Message | Richard Baratta | 2011-01-11 10:39:09 | BUG #5830: Cannot connect to the server |