| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | CHECK() Constraint on Column Using Lookup Table |
| Date: | 2007-05-01 17:41:44 |
| Message-ID: | Pine.LNX.4.64.0705011036500.22056@salmo.appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've seen the syntax for using a lookup table in a CHECK() constraint, but
I cannot find a reference to it. It's not in Section 5.3.1 of the 8.2 docs.
Specifically, I want to reference a table of ISO 2-letter codes for US
states and Canadian provinces/territories in a table with name and address
columns.
Please point me to a reference.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-05-01 17:53:59 | Re: CHECK() Constraint on Column Using Lookup Table |
| Previous Message | Arturo | 2007-05-01 17:39:33 | Re: [GENERAL] Indice en Date |