Thread

1. 7.0.2: Arrays

   Larry Rosenman <ler@lerctr.org> — 2000-09-05T19:56:30Z

   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));
   ERROR:  parser: parse error at or near "["
   ler=# create table ia_standby (hsrp_group int2,
   ler(# 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
   
   

2. Re: [HACKERS] 7.0.2: Arrays

   Kristofer Munn <kmunn@munn.com> — 2000-09-05T20:22:39Z

   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/
   
   
   

3. Re: [HACKERS] 7.0.2: Arrays

   Larry Rosenman <ler@lerctr.org> — 2000-09-05T20:30:20Z

   Ok, so I can't read.  Thanks!
   
   LER
   
   * Kristofer Munn <kmunn@munn.com> [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
   
   

4. Re: 7.0.2: Arrays

   Jie Liang <jliang@ipinc.com> — 2000-09-05T20:38:47Z

   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