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

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

dax duskin


pgsql-novice by date

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

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