<div class="Section1"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family:
Arial;">Help! </span></font><br/><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy;
font-family:Arial;">I’m trying to use array_to_string on the pg_stats column histogram_bounds…</span></font><br /><font
color="navy"face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;"><br /> test83=#
selectarray_to_string(histogram_bounds::anyarray, '-') from pg_stats where attname = ‘id' and tablename =
‘widgets’;</span></font><br/><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy;
font-family:Arial;">ERROR: argument declared "anyarray" is not an array but type anyarray</span></font><br /><font
color="navy"face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;"> </span></font><br
/><fontcolor="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family:
Arial;"> </span></font><br/><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy;
font-family:Arial;">In 8.1, it worked fine…</span></font> <font color="navy" face="Arial" size="2"><span
style="font-size:10pt; color: navy; font-family: Arial;"> </span></font><br /><font color="navy" face="Arial"
size="2"><spanstyle="font-size: 10pt; color: navy; font-family: Arial;">test81=# select
array_to_string(histogram_bounds::anyarray,'-') from pg_stats where attname = 'id' and tablename =
'widgets';</span></font><br/><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy;
font-family:Arial;"> array_to_string</span></font><br /><font
color="navy"face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family:
Arial;">---------------------------------------------------------------------------------------------------------------------</span></font><br
/><fontcolor="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family:
Arial;"> 140554732-572177261-753193757-830984044-942651560-1085142858-1287313768-1418796327-1623947492-1865024250-3199068162</span></font><br
/><fontface="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font><br /><font face="Arial"
size="2"><spanstyle="font-size: 10pt; font-family: Arial;">Any help would be appreciated,</span></font> whether a known
fixto this, or any workaround you can think of.<br /><br /> Thanks!<br /><font face="Arial" size="2"><span
style="font-size:10pt; font-family: Arial;">Corey Horton</span></font><br /><font face="Arial" size="2"><span
style="font-size:10pt; font-family: Arial;"> </span></font></div>
