Postgres Pro
Downloads
Home   >   mailing lists

Tables Referencing themselves As Foreign Keys - Mailing list pgsql-general

From Tony (Unihost)
Subject Tables Referencing themselves As Foreign Keys
Date
Msg-id 3FE6CE27.5080102@unihost.net
Whole thread Raw
Responses Re: Tables Referencing themselves As Foreign Keys  (Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>)
Re: Tables Referencing themselves As Foreign Keys  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
Tree view 
Hi,

I'm still new to this so if I'm sounding dumb or my premise is flawed
please forgive me.  I have a DB design which contains a table which has
categories, each category has a parent category, and is recursed until
the top category is reached, in order to create breadcrumbs.  Is there
any problem with using foreign keys to reference the same table?  So a
when category is added the CatParent MUST be present as a CatID

CatID - Serial
CatParent - int4 - References CatID
CatName - Text

Am I likeley to come unstuck with this?

Cheers

T.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Groff and Weinberg SQL Complete Reference - Sample database?
Next
From: Oleg Bartunov
Date:
Subject: Re: questions about tsearch2 (for czech language)