Re: Table-design for categories, suggestions needed

From: Lew <noone(at)lewscanon(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Table-design for categories, suggestions needed
Date: 2010-08-07 12:28:37
Message-ID: i3jjgi$ake$1@news.albasani.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

gargoyle60 wrote:
>>> Oops, that should read...
>>> ...
>>> FOREIGN KEY (parent_level)
>>> REFERENCES category (category_level)

Lew wrote:
>> So category (category_level) is a unique or primary key, then.

gargoyle60 wrote:
> Something like that,

It would have to be exactly like that or you wouldn't be able to point a
foreign key to it.

> probably with (category_level, category_code).

Then you'll need a two-column foreign key.

> Like I said, I never got around to implementing the provisional design and there may be more to it
> than that.

--
Lew

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jean-Yves F. Barbier 2010-08-07 15:40:50 Re: Table-design for categories, suggestions needed
Previous Message Victor Hugo 2010-08-07 12:27:26 Re: Table-design for categories, suggestions needed