Re: How to order a list with a self-referential foreign key? (a category list)

I've found what I was looking for, and it turns out it's not simple at all. Storing hierarchical information in a database is challenging and there are several SQL techniques that can be applied to the problem. There are a few good Django implementations out there, including django-categories, dj

How to order a list with a self-referential foreign key? (a category list)

I have a list of categories that allows you to set a parent/child relationship such as: Financial Financial > Billing Financial > Billing > Collections Financial > Invoices In the example above, "Financial" is a category, then "Billing" is a category with "Financial" as the parent, etc.