Re: [DOCS] CONSTRAINT on ARRAY ELEMENTS

2012-11-04 Thread Dmitriy Igrishin
Hey Nikolaos, 2012/11/3 Nikolaos Ikonomopoulos > > CREATE TABLE employ_presence > ( > p_id character(6) not null, > p_month character(3) NOT NULL, > *statuscode* integer array[7], > CONSTRAINT unq_employ_presence UNIQUE (p_id, p_month), > CONSTRAINT chk_employ_month CHECK (p_month = AN

Re: [DOCS] CONSTRAINT on ARRAY ELEMENTS

2012-11-04 Thread Jeff Davis
On Sat, 2012-11-03 at 09:43 +, Nikolaos Ikonomopoulos wrote: > > CREATE TABLE employ_presence > ( > p_id character(6) not null, > p_month character(3) NOT NULL, > statuscode integer array[7], > CONSTRAINT unq_employ_presence UNIQUE (p_id, p_month), > CONSTRAINT chk_employ_month CHECK