Re: Can I use a constraint to make sure all array elements are positive?

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