Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 - Mailing list pgsql-sql

From Corey Horton
Subject Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
Date
Msg-id 4945A74B.9020905@austin.rr.com
Whole thread Raw
In response to 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
Next
From: Louis-David Mitterrand
Date:
Subject: Re: optimizing a query