Add a check an a array column

Поиск
Список
Период
Сортировка
От vdg
Тема Add a check an a array column
Дата
Msg-id 1530961.uh54oR6Eve@vdg-dev
обсуждение исходный текст
Ответы Re: Add a check an a array column
Список pgsql-general
Hello,

I have a column defined as

test bigint[]

I would like to add a constraint on this column:  the values stored must be
between 0 and 1023 inclusive

I know how to add a constraint on a column which is not an array:

check (test < x'400'::bigint)

but i can't find the way to do that when there is an array of values



Any help ?

Thank you

vdg


В списке pgsql-general по дате отправления: