Postgres Pro
Downloads
Home   >   mailing lists

Re: CHECK() Constraint on Column Using Lookup Table - Mailing list pgsql-general

From Rich Shepard
Subject Re: CHECK() Constraint on Column Using Lookup Table
Date
Msg-id Pine.LNX.4.64.0705011109000.22056@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: CHECK() Constraint on Column Using Lookup Table  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
On Tue, 1 May 2007, Joshua D. Drake wrote:

> You could use a function, or a foreign key.

Josh,

   The foreign key approach will do nicely.

Thanks,

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: CHECK() Constraint on Column Using Lookup Table
Next
From: Michael Glaesemann
Date:
Subject: Re: CHECK() Constraint on Column Using Lookup Table