| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Greg Stark <greg(dot)stark(at)enterprisedb(dot)com> |
| Cc: | Corey Horton <chorton1(at)austin(dot)rr(dot)com>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
| Date: | 2008-12-14 01:10:09 |
| Message-ID: | 14986.1229217009@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
Greg Stark <greg(dot)stark(at)enterprisedb(dot)com> 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(histogram_bounds::text[], '-') from pg_stats where attname = 'unique2' and tablename = 'tenk1';
ERROR: cannot cast type anyarray to text[]
LINE 1: select array_to_string(histogram_bounds::text[], '-') from ...
^
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2008-12-14 01:12:10 | Re: Stats target increase vs compute_tsvector_stats() |
| Previous Message | Greg Stark | 2008-12-14 00:52:28 | Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-12-14 18:16:03 | Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |
| Previous Message | Greg Stark | 2008-12-14 00:52:28 | Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 |