On Tue, Dec 21, 2010 at 9:32 PM, Andy Chambers <achambers@xxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
