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

From: Corey Horton <chorton1(at)austin(dot)rr(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3
Date: 2008-12-13 05:03:12
Message-ID: 49434210.1070007@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Asko Oja 2008-12-13 08:11:33 Re: WIP: default values for function parameters
Previous Message KaiGai Kohei 2008-12-13 03:24:06 Re: Updates of SE-PostgreSQL 8.4devel patches (r1268)

Browse pgsql-sql by date

  From Date Subject
Next Message Pascal Tufenkji 2008-12-13 07:33:54 Re: Is there a bug in PostgreSQL ?
Previous Message Tom Lane 2008-12-11 14:40:07 Re: Is there a bug in PostgreSQL ?