Rich Shepard wrote:
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.
You could use a function, or a foreign key.
Joshua D. Drake
Rich
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
