[sqlite] SQL tree and deepness level

[Robert Zajda]

Hello

I have a table
CREATE TABLE acategories {
   id integer not null primary key
   category string
   parent_category integer references acategories.id
)

query:
SELECT
   a.id AS 'id',
   a.category AS 'Category',
   b.category AS 'Parent category'
FROM acategories AS a
LEFT JOIN acategories AS b ON a.parent_category=b.id

everything works ok, but i need to add new field with deepness level
of each row.
Is it possible ?

Thanks
Robert

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------