Skip site navigation (1) Skip section navigation (2)

Re: array column problem

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: (view raw, whole thread or download thread mbox)
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

Subject:  Re: [NOVICE] array column problem

Dear Dax

Just checked  Momijan's book.
It should be
insert into tablename values(1, '{1,2,3}');

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: att1.eml
Description: application/octet-stream (1.5 KB)

pgsql-novice by date

Next:From: Ken CoreyDate: 2001-03-13 15:55:48
Subject: Re: Fwd: Silly question about numbering of rows?
Previous:From: Dax DuskinDate: 2001-03-13 15:48:30
Subject: Re: perl installation problem and installation of postgres from rpms

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group