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
Дата	13 декабря 2008 г. 19:08:12
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

Дерево обсуждения

Help!
I’m trying to use array_to_string on the pg_stats column histogram_bounds…

test83=# select array_to_string(histogram_bounds::anyarray, '-') from pg_stats where attname = ‘id' and tablename = ‘widgets’;
ERROR: argument declared "anyarray" is not an array but type anyarray

In 8.1, it worked fine…
test81=# select array_to_string(histogram_bounds::anyarray, '-') from pg_stats where attname = 'id' and tablename = 'widgets';
array_to_string
---------------------------------------------------------------------------------------------------------------------
140554732-572177261-753193757-830984044-942651560-1085142858-1287313768-1418796327-1623947492-1865024250-3199068162

Any help would be appreciated, whether a known fix to this, or any workaround you can think of.

Thanks!
Corey Horton

В списке pgsql-sql по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3