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.

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