Re: Add a check an a array column - Mailing list pgsql-general

vdg <vdg.encelade@gmail.com> writes:
> Before posting, I had tried something like

> check ((ALL(i) >= 0) AND (ALL(i) <= 1024  )));

> but i got syntax errors.

Well, that's not the syntax.

> Could someone give me documentation hints on this behaviour ?

http://www.postgresql.org/docs/9.1/static/functions-subquery.html#FUNCTIONS-SUBQUERY-ALL
http://www.postgresql.org/docs/9.1/static/functions-comparisons.html#AEN17447

            regards, tom lane