array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
От | Corey Horton |
---|---|
Тема | array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
Дата | |
Msg-id | 49434210.1070007@austin.rr.com обсуждение исходный текст |
Ответы |
Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
|
Список | pgsql-sql |
<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>
В списке pgsql-sql по дате отправления: