Re: [NOVICE] Array Problem

John Burski <John.Burski@911ep.com> writes:
> If I specify a particular array subscipt, for example:
>      SELECT name, links[1] FROM testa;
> I get an error message that says:
>      ERROR:  Unable to locate type name 'vals' in catalog

In 6.5.* and earlier, you have to write out "testa.links[1]", IIRC.

> Any suggestions?  Upgrading to 7.0 is not an option at the present time.

The above is just one of a depressingly large number of array-related
bugs fixed in 7.0.  Not to mention a lot of non-array-related bugs fixed
in 7.0.  I strongly recommend that you update.

            regards, tom lane