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.
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 |