two constrains for one column

From: Ben-Nes Michael <miki(at)canaan(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: two constrains for one column
Date: 2001-07-19 07:50:40
Message-ID: 3B569150.6070201@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
);

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janning Vygen 2001-07-19 08:34:04 Re: PG rules! (RULES being the word ;->)
Previous Message Ben-Nes Michael 2001-07-19 07:08:29 Re: VACUUM ANALYZE