Hi,
This example is straight from bruce's book but I am getting an error. Help!
[PostgreSQL 6.5.3 on i386-pc-bsdi3.0, compiled by gcc2 ]
test=> create table array_test (col1 integer[5], col2 integer[][],
test-> col3 integer[2][2][]);
CREATE
test=> insert into array_test values('{1,2,3,4,5}', '{{1,2},{3,4}}'
test-> , '{{{1,2},{3,4}},{{5,6},{7,8}}}');
INSERT 6498581 1
test=> select * from array_test;
col1 |col2 |col3
-----------+-------------+-----------------------------
{1,2,3,4,5}|{{1,2},{3,4}}|{{{1,2},{3,4}},{{5,6},{7,8}}}
(1 row)
test=> select col1[4] from array_test;
ERROR: Unable to locate type name 'col1' in catalog
test=>
Thanks,
John Henderson
