Re: [SQL] hi i want help on levels

2006-10-18 Thread Jim C. Nasby
Search the archives for hierarchical query. -- Jim Nasby[EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[SQL] hi i want help on levels

2006-10-16 Thread Penchalaiah P.
CREATE TABLE admin_activity (   activity_id int4 NOT NULL,   Activity_name varchar NOT NULL,   URL varchar,   parent_activity_id int4);   1  Administration   0 2  Activities   1 3  Manage Activity 2 4  Map