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
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) |
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 ? |