Re: [GENERAL] unexpected error with array

2000-03-24 Thread Tatsuo Ishii
> 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 ] [snip] > test=> select col1[4] from array_test; > ERROR: Unable to locate type name 'col1' in catalog This is a known bug and will be fixed in 7.0. I think

[GENERAL] unexpected error with array

2000-03-23 Thread John Henderson
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}', '{{