Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
| От | Corey Horton |
|---|---|
| Тема | Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
| Дата | |
| Msg-id | 4945A74B.9020905@austin.rr.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-sql |
Fantastic - I'll just if/else the query based on db version.<br /><br /> Thanks!<br /> Corey<br /><br /> Tom Lane wrote:<blockquote cite="mid:2304.1229284683@sss.pgh.pa.us" type="cite"><pre wrap="">Corey Horton <a class="moz-txt-link-rfc2396E"href="mailto:chorton1@austin.rr.com"><chorton1@austin.rr.com></a> writes: </pre><blockquotetype="cite"><pre wrap="">Is there any known workaround to get this the elements of the histogram_bounds anyarray in 8.3.5. </pre></blockquote><pre wrap=""> It appears that you could explicitly cast to text and thence to text[]: select array_to_string(histogram_bounds::text::text[], '-') from ... but this might be too ugly for your taste. </pre><blockquote type="cite"><pre wrap="">If not, when might I expect a fix? </pre></blockquote><pre wrap=""> 8.3.6, or apply <a class="moz-txt-link-freetext" href="http://archives.postgresql.org/pgsql-committers/2008-12/msg00109.php">http://archives.postgresql.org/pgsql-committers/2008-12/msg00109.php</a> regards, tom lane </pre></blockquote>
В списке pgsql-sql по дате отправления: