Array issue....

From: dba <dbadbb(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Array issue....
Date: 2011-02-14 11:51:52
Message-ID: 1297684312397-3384334.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Array-issue-tp3384334p3384334.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Chetan Suttraway 2011-02-14 12:16:48 Re: Array issue....
Previous Message vegard.bones 2011-02-14 11:40:40 BUG #5883: Error when mixing SPI_returntuple with returning regular HeapTuple