array column problem - Mailing list pgsql-novice

From Dax Duskin
Subject array column problem
Date
Msg-id 86256A0D.00624E90.00@zsserver3.zsassociates.com
Whole thread Raw
List pgsql-novice
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.

Any ideas?  I pretty much copied the format out of Momijan's book.

thanks,
dax duskin



pgsql-novice by date:

Previous
From: "Anthony E . Greene"
Date:
Subject: Re: Run Time Variables
Next
From: "Constantin"
Date:
Subject: check for table existence before dropping