Re: [BUGS] Array issue....

2011-02-14 Thread Tatsuhito Kasahara
dba wrote: I wanted to create index 0f 3 numeric array. But it is allowing to insert more than 4 elements CREATE TABLE abs(no int[3]); CREATE TABLE zivah=# INSERT INTO abs VALUES('{1,3,34,343,4342342,342}'); INSERT 0 1 I need a solution to store an elements exactly 3. More than 3 should not

Re: [BUGS] Array issue....

2011-02-14 Thread Chetan Suttraway
On Mon, Feb 14, 2011 at 5:21 PM, dba wrote: > > > I wanted to create index 0f 3 numeric array. But it is allowing to insert > more than 4 elements > > CREATE TABLE abs(no int[3]); > CREATE TABLE > > zivah=# INSERT INTO abs VALUES('{1,3,34,343,4342342,342}'); > INSERT 0 1 > > I need a solution to

[BUGS] Array issue....

2011-02-14 Thread dba
I wanted to create index 0f 3 numeric array. But it is allowing to insert more than 4 elements CREATE TABLE abs(no int[3]); CREATE TABLE zivah=# INSERT INTO abs VALUES('{1,3,34,343,4342342,342}'); INSERT 0 1 I need a solution to store an elements exactly 3. More than 3 should not be allowed.