From: | Nikolaos Ikonomopoulos <ikonomn(at)hotmail(dot)com> |
---|---|
To: | <pgsql-docs(at)postgresql(dot)org> |
Subject: | CONSTRAINT on ARRAY ELEMENTS |
Date: | 2012-11-03 09:43:06 |
Message-ID: | DUB103-W19690C266F73C74A461C7CA0660@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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 = ANY (ARRAY['Jan'::bpchar, 'Feb'::bpchar, 'Mar'::bpchar, 'Apr'::bpchar, 'May'::bpchar, 'Jun'::bpchar, 'Jul'::bpchar, 'Aug'::bpchar, 'Sep'::bpchar, 'Oct'::bpchar, 'Nov'::bpchar, 'Dec'::bpchar]))
);
How can add a CONSTRAINT on statuscode array elements to accept values between 0 to 5
0 = Employ present
1 = Employ Patient
2 = day off
3 = Regular vacation
4 = external job assignment
5 = external job assignment abroad
6 to 9 for future use
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitriy Igrishin | 2012-11-04 09:54:41 | Re: CONSTRAINT on ARRAY ELEMENTS |
Previous Message | Andre Majorel | 2012-11-02 16:28:39 | Re: Formatting complaints |