On 03/19/2014 10:59 PM, AlexK wrote:
> One of the columns in my table is FLOAT[] NOT NULL. Can I use a constraint to
> make sure all array elements are positive?
You can make a function that checks an array, and then use that in a
CHECK constraint.
Also, note that select array[null]::float[] is null; returns false.
That may not be what you want.
--
Vik