| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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...... |