I think you need to do:
insert into tablename values('{1}, {1,2,3}');
Note brackets an single quotes.
--rob
----- Original Message -----
From: "Dax Duskin" <dax.duskin@zsassociates.com>
To: <pgsql-novice@postgresql.org>
Sent: Monday, March 12, 2001 12:06 PM
Subject: array column problem
> Hi all,
>
> I'm having some trouble setting a column to use arrays.
>
> Here's an example of what I am trying to do:
>
> create table tablename (index INTEGER, numarray INTEGER[]);
>
> insert into tablename values(1, {1,2,3});
>
> I receive the "Parser error at or near '{'" error.
>
> Any ideas? I pretty much copied the format out of Momijan's book.
>
> thanks,
> dax duskin
>
>
>
