Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by hub.org (8.10.1/8.10.1) with ESMTP id e85KUNB88418; Tue, 5 Sep 2000 16:30:23 -0400 (EDT) Received: (from ler@localhost) by lerami.lerctr.org (8.11.0/8.11.0/20000901) id e85KUK420966; Tue, 5 Sep 2000 15:30:20 -0500 (CDT) (envelope-from ler) Date: Tue, 5 Sep 2000 15:30:20 -0500 From: Larry Rosenman To: Kristofer Munn Cc: pgsql-hackers@hub.org, pgsql-sql@hub.org Subject: Re: [HACKERS] 7.0.2: Arrays Message-ID: <20000905153020.A20508@lerami.lerctr.org> References: <20000905145630.A19424@lerami.lerctr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from kmunn@munn.com on Tue, Sep 05, 2000 at 04:22:39PM -0400 X-Mailer: Mutt http://www.mutt.org/ X-Archive-Number: 200009/23 Ok, so I can't read. Thanks! LER * Kristofer Munn [000905 15:27]: > 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/ -- 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