Re: Array Problem

On Wed, 1 Nov 2000, John Burski wrote:

> I'm working with version 6.5.2 and I've created a test table that
> contains both a one and a two dimensional array.
>
>      CREATE TABLE testa (
>      name text,
>      links int2[],
>      vals int2[][] );
>
> I'v populated the table with at least one record, so I should be able
> run 'select' requests that deliver something *meaningful*.
>
> If I select everything or specify an entire array, the query works OK.
>
>      SELECT name, links FROM testa;        # OK
>
> 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
>
> Yet the documentation seems to indicate that this is a valid *select*
> statement.

Since I don't have 6.5 floating around anymore I can't check it.  I do
see that it works on CVS sources and on 7.0.  My guess is that it was
a bug fixed between versions.  If you can't go up to 7.0, you might
see about trying 6.5.3 just to see if a fix was backpatched.