Re: two constrains for one column

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: miki(at)canaan(dot)co(dot)il
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: two constrains for one column
Date: 2001-07-19 08:51:10
Message-ID: 20010719085110.14088.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message markMLl.pgsql-general 2001-07-19 09:48:05 Re: Migration
Previous Message Janning Vygen 2001-07-19 08:34:04 Re: PG rules! (RULES being the word ;->)