positive bigint arrays

From: SpinDFazor <philaltist(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: positive bigint arrays
Date: 2013-08-26 14:22:48
Message-ID: 1377526968938-5768576.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
Newbie to pgsql here. I would like to
ADD COLUMN "Scan resolution" bigint[]
This works. However, how can I add a constraint that will check each member
of the bigint array for being positive ?
Any syntax I could think off for CONSTRAINT is raising an error due to type
mismatch between my array and zero;
ALTER TABLE "MRI_data" ADD COLUMN MatrixDims bigint[] CONSTRAINT
positive_dims CHECK (MatrixDims > 0);

in other words, how can I specify "any" member of the array ? I tried
without success
MatrixDims{:} > 0
MatrixDims[:] > 0
MatrixDims{} >0
MatrixDims[] > 0
MatrixDims > 0

Any help greatly appreciated. Surprisingly I could find tons on validation
but nothing on validation of arrays.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/positive-bigint-arrays-tp5768576.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Miguel Beltran R. 2013-08-26 18:02:09 Re: positive bigint arrays
Previous Message Luca Ferrari 2013-08-23 14:40:22 Re: Linux group access to ..../psql/data & subdirectories