Received: from munn.com ([216.10.14.229]) by hub.org (8.10.1/8.10.1) with ESMTP id e85KMmB86171; Tue, 5 Sep 2000 16:22:48 -0400 (EDT) Received: from localhost (kmunn@localhost) by munn.com (8.9.3/8.9.1) with ESMTP id QAA12508; Tue, 5 Sep 2000 16:22:40 -0400 Date: Tue, 5 Sep 2000 16:22:39 -0400 (EDT) From: Kristofer Munn To: Larry Rosenman cc: pgsql-hackers@hub.org, pgsql-sql@hub.org Subject: Re: [HACKERS] 7.0.2: Arrays In-Reply-To: <20000905145630.A19424@lerami.lerctr.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200009/26 On Tue, 5 Sep 2000, 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), > ler(# routers[] varchar(64)); What you want to do is... create table ia_standby ( hsrp_group int2, router_interfaces varchar(64)[], routers varchar(64)[] ); - K Kristofer Munn * KMI * 732-254-9305 * AIM KrMunn * http://www.munn.com/