CHECK() Constraint on Column Using Lookup Table
От
Rich Shepard
Тема
CHECK() Constraint on Column Using Lookup Table
Дата
Msg-id
Pine.LNX.4.64.0705011036500.22056@salmo.appl-ecosys.com
Список
Дерево обсуждения
CHECK() Constraint on Column Using Lookup Table Rich Shepard <rshepard@appl-ecosys.com>
Re: CHECK() Constraint on Column Using Lookup Table "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: CHECK() Constraint on Column Using Lookup Table "Joshua D. Drake" <jd@commandprompt.com>
Re: CHECK() Constraint on Column Using Lookup Table Rich Shepard <rshepard@appl-ecosys.com>
Re: CHECK() Constraint on Column Using Lookup Table Richard Broersma Jr <rabroersma@yahoo.com>
Re: CHECK() Constraint on Column Using Lookup Table "Dann Corbit" <DCorbit@connx.com>
Re: CHECK() Constraint on Column Using Lookup Table "Dann Corbit" <DCorbit@connx.com>
Re: CHECK() Constraint on Column Using Lookup Table Rich Shepard <rshepard@appl-ecosys.com>
Re: CHECK() Constraint on Column Using Lookup Table Michael Glaesemann <grzm@seespotcode.net>
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)
Voice: 503-667-4517 Fax: 503-667-8863
В списке pgsql-general по дате отправления
