Re: How to represent a tree-structure in a relational database

Ron Peterson wrote:
>
> CREATE TABLE category_edge (
> parent INTEGER
> NOT NULL
> REFERENCES category_node(id),
>
> child INTEGER
> NOT NULL
> REFERENCES category_node(id)
> );

Just for the sake of anal-retentive completeness, I'd like to point out
that you'd probably want an id field in this table also. Plus what the
heck else am I going to do on Christmas break? ;)

On a completely unrelated topic: getting the PostgreSQL discussions
lists on a news server is great!!! I was overwhelmed with mail that I
usually don't have time to deal with. Now when I have a chance, I just
go see what's up on the news server. Excellent and thanks!

-Ron-