On Mon, 2003-12-22 at 05:57, Tony (Unihost) wrote:
> 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
>
Hmm... breadcrubs make me think you should look at using a nested set.
(Google "nested set celko" for more info)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL