Received: from puma.zsassociates.com ([172.16.200.55]) by zsserver3.zsassociates.com (Lotus SMTP MTA v4.6.7  (934.1 12-30-1999)) with SMTP id 86256A0E.00571A64; Tue, 13 Mar 2001 09:51:23 -0600
Received: from giaspn01.vsnl.net.in (ddn-gateway [192.68.1.248])
	by puma.zsassociates.com (8.9.3+Sun/8.9.1) with ESMTP id JAA23123
	for <dax.duskin@zsassociates.com>; Tue, 13 Mar 2001 09:51:21 -0600 (CST)
Received: from giaspn01.vsnl.net.in (RAS49_11.ppppun.vsnl.net.in [203.197.82.11])
	by giaspn01.vsnl.net.in (Postfix) with ESMTP id 1A52D2379
	for <dax.duskin@zsassociates.com>; Tue, 13 Mar 2001 21:48:06 +0530 (IST)
Sender: deval@giaspn01.vsnl.net.in
Message-ID: <3AAE4113.DC535D3A@giaspn01.vsnl.net.in>
Date: Tue, 13 Mar 2001 21:17:31 +0530
From: Vijay Deval <deval@giaspn01.vsnl.net.in>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Dax Duskin <dax.duskin@zsassociates.com>
Subject: Re: [NOVICE] array column problem
References: <86256A0D.00624E90.00@zsserver3.zsassociates.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
>



