array column problem

From: "Dax Duskin" <dax(dot)duskin(at)zsassociates(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: array column problem
Date: 2001-03-12 17:06:30
Message-ID: 86256A0D.00624E90.00@zsserver3.zsassociates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2001-03-12 18:18:59 Re: counting rows of grouped query (problem with views)
Previous Message Anthony E . Greene 2001-03-11 13:57:19 Re: Run Time Variables