From: | "Dax Duskin" <dax(dot)duskin(at)zsassociates(dot)com> |
---|---|
To: | Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: array column problem |
Date: | 2001-03-13 15:53:48 |
Message-ID: | 86256A0E.00577C43.00@zsserver3.zsassociates.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks Vijay.
> insert into tablename values(1, '{1,2,3}');
It's amazing what the eyes miss when you haven't had enough coffee.
Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in> on 03/13/2001 09:47:31 AM
To: Dax Duskin/Evanston/ZSAssociates(at)ZSAssociates
cc:
Subject: Re: [NOVICE] array column problem
Dear Dax
Just checked Momijan's book.
It should be
insert into tablename values(1, '{1,2,3}');
Vijay
Dax Duskin wrote:
> Hi all,
>
> I'm having some trouble setting a column to use arrays.
> Here's an example of what I am trying to do:
> create table tablename (index INTEGER, numarray INTEGER[]);
> insert into tablename values(1, {1,2,3});
> I receive the "Parser error at or near '{'" error.
> thanks,
> dax duskin
>
Attachment | Content-Type | Size |
---|---|---|
att1.eml | application/octet-stream | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Corey | 2001-03-13 15:55:48 | Re: Fwd: Silly question about numbering of rows? |
Previous Message | Dax Duskin | 2001-03-13 15:48:30 | Re: perl installation problem and installation of postgres from rpms |