Treestructure in SQL

[Bruno Desthuilliers]

Thomas Weholt wrote:
> Hi,
> 
> I need to define tree-like structure for content categories in a simple CMS
> project. I got a table in a SQLite database which looks like this :
> 
>     CREATE TABLE category (
>       CAT_ID INTEGER PRIMARY KEY,
>       CAT_PARENT_ID integer,
>       CAT_NAME varchar(100) NOT NULL,
>       CAT_DESCRIPTION varchar(250),
>     );
> 

(snip)

> 
> Any clues or hints??

You may want to read this :
http://c2.com/cgi/wiki?TreeInSql

HTH
Bruno