From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Larry Rosenman <ler(at)lerctr(dot)org> |
Cc: | pgsql-hackers(at)hub(dot)org, pgsql-sql(at)hub(dot)org |
Subject: | Re: 7.0.2: Arrays |
Date: | 2000-09-05 20:38:47 |
Message-ID: | 39B559D7.FE4E215D@ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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(at)lerctr(dot)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(at)ipinc(dot)com
www.ipinc.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-09-05 22:39:03 | Re: Crash on userdefined operator |
Previous Message | Larry Rosenman | 2000-09-05 20:30:20 | Re: [HACKERS] 7.0.2: Arrays |
From | Date | Subject | |
---|---|---|---|
Next Message | Poet/Joshua Drake | 2000-09-06 05:41:14 | 8K Limit, and Replication |
Previous Message | Larry Rosenman | 2000-09-05 20:30:20 | Re: [HACKERS] 7.0.2: Arrays |