Re: positive bigint arrays

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.


--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice