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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
Следующее
От: Louis-David Mitterrand
Дата:
Сообщение: Re: optimizing a query