Jeff Davis wrote on 25.07.2009 22:44:
> It's generally hard to work with values of type anyarray. You have to
> cast them to text and then to a normal array type.
>
> For example:
>
> select unnest(histogram_bounds::text::oid[]) from pg_stats where
> tablename='pg_amop' and attname='amopopr';
Great, thanks
I tried casting the column to text[] (because it contains elements of type text) but I didn't think
of doing a two way cast.
Do I understand this correctly that by casting it first to text, I effectively create a new array
the same way I create one, when I supply a literal like '{1,2,3}'::text[]
Thomas