Array Problem

From: John Burski <John(dot)Burski(at)911ep(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Array Problem
Date: 2000-11-01 16:30:48
Message-ID: 3A004538.5D2259C@911ep.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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.

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

Thanks.

--
John Burski
Lead Programmer
911 Emergency Products, Inc.
St. Cloud, MN 56301

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Louis-David Mitterrand 2000-11-01 16:38:36 a web interface to visualize tables
Previous Message Oliver_Hall 2000-11-01 15:33:01 Re: Case insensitive LIKE queries

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2000-11-01 17:07:11 Re: Array Problem
Previous Message Poul L. Christiansen 2000-11-01 13:34:16 Re: pg_hba.conf , problem......