Thread: two constrains for one column

Hi All

im trying to do the next thing, is it possible ?

CREATE TABLE language (
language serial PRIMARY KEY,
shortcut char(2) NOT NULL, unique, -- like il,en,fr,sp
);

Yes, definitely.  Just do:

CREATE TABLE language (
language serial PRIMARY KEY,
shortcut char(2) NOT NULL UNIQUE -- like il,en,fr,sp
);

and it should be fine.

Constraints are good.