You may want to have a look at pg DOMAIN (also conforms to SQL standard).
http://www.postgresql.org/docs/8.0/static/sql-createdomain.html
Regards,
Qingqing
"Dale Sykora" <[EMAIL PROTECTED]> writes
> I am building a database that has about 20 fields in various tables that
> I would like to con
I am building a database that has about 20 fields in various tables that
I would like to constrain to a small group (<=5) of choices. Rather
that refer to 20 seperate tables, I would like to refer to 1 table that
contained category and choice fields.
for example
choices table
category | choic
