Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e85KfFB91816; Tue, 5 Sep 2000 16:41:15 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id NAA65941; Tue, 5 Sep 2000 13:41:03 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39B559D7.FE4E215D@ipinc.com> Date: Tue, 05 Sep 2000 13:38:47 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: Larry Rosenman CC: pgsql-hackers@hub.org, pgsql-sql@hub.org Subject: Re: 7.0.2: Arrays References: <20000905145630.A19424@lerami.lerctr.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/24 Hi, there Your syntax is not correct, pls check the Pg documentatation, the correction as following. Larry Rosenman wrote: > Greetings, > I was trying to use arrays today, and can't seem to get it right. > > What am I doing wrong? > > ler=# create table ia_standby (hsrp_group int2, > ler(# router_interfaces[] varchar(64), ==>router_interfaces varchar(64)[], > > ler(# routers[] varchar(64)); > ERROR: parser: parse error at or near "[" > ler=# create table ia_standby (hsrp_group int2, > ler(# router_interfaces[] text, ==>router_interfaces text[], > > ler(# routers[] text); > ERROR: parser: parse error at or near "[" > ler=# > > -- > Larry Rosenman http://www.lerctr.org/~ler > Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org > US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com