Subject: Re: [NOVICE] array column problem
From: Vijay Deval <[email-masked]>
To: Dax Duskin <[email-masked]>
Date: Tue, 13 Mar 2001 21:17:31 +0530

Dear Dax

Just checked  Momijan's book.
It should be
insert into tablename values(1, '{1,2,3}');
Vijay

Dax Duskin wrote:

> 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.
> thanks,
> dax duskin
>