From: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: foreign key help |
Date: | 2005-03-17 06:08:52 |
Message-ID: | d1b76l$310t$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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" <dalen(at)czexan(dot)net> writes
> 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 | choice
> -----------------
> color | red
> color | green
> size | small
> size | big
> shape | circle
> shape | square
>
> item table
>
> item | shape
> -----------------
> box | constrain to choices(choice) where category='shape'
>
>
>
> Is there an easy way to do this, or is it better to have many
> choices_category tables?
>
> Thanks,
>
> Dale
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-03-17 06:35:33 | Re: Object like pg_class.relkind = 's' or 'c' have on-disk file? |
Previous Message | Qingqing Zhou | 2005-03-17 06:01:38 | Re: Object like pg_class.relkind = 's' or 'c' have on-disk file? |