Re: array column problem

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(dot)duskin(at)zsassociates(dot)com>
To: <pgsql-novice(at)postgresql(dot)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
>
>
>