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
Corey Horton writes:
> 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
Huh, I didn't realize that ever worked in the past. I thought the way
to do what the op describes was to cast it to text[] or whatever
datatype you from out-of-band knowledge to expect.
--
Greg
On 13 Dec 2008, at 19:38, Tom Lane wrote:
Corey Horton writes:
I'm trying to use array_to_st
Greg Stark writes:
> Huh, I didn't realize that ever worked in the past. I thought the way
> to do what the op describes was to cast it to text[] or whatever
> datatype you from out-of-band knowledge to expect.
We don't seem to allow that either ...
regression=# select array_to_string(histog
