On Tue, Dec 21, 2010 at 9:32 PM, Andy Chambers <achambers@mcna.net> wrote:
\
> create table guidebooks (
> city check (city in (select name
> from cities)),
> isbn text,
> author text,
> publisher text);
This is a nice idea. They only problem is that PostggreSQL doesn't
support sub-selects in a tables check constraints:
http://www.postgresql.org/docs/9.0/interactive/sql-createtable.html
--
Regards,
Richard Broersma Jr.