cojack

ltree=> SELECT * FROM tree;
 idCategory |         categoryPath
------------+------------------------------
         27 | 1.Top
         28 | 1.Top.1.Science
         29 | 1.Top.2.Hobby
         30 | 1.Top.3.Colors
         31 | 1.Top.1.Science.1.Physics
         32 | 1.Top.1.Science.2.Chemistry
         33 | 1.Top.1.Science.3.Biology
         34 | 1.Top.1.Science.4.History
         35 | 1.Top.2.Hobby.1.Fishing
         36 | 1.Top.2.Hobby.2.Football
         37 | 1.Top.3.Colors.1.Black
         38 | 1.Top.3.Colors.2.Red
         39 | 1.Top.3.Colors.3.Blue
         40 | 1.Top.1.Science.5.Archeology
         41 | 1.Top.2.Hobby.3.Swimming
         42 | 1.Top.3.Colors.4.Gray
         43 | 1.Top.3.Colors.5.Purple
         44 | 1.Top.3.Colors.6.Brown
         45 | 1.Top.2.Hobby.4.Climbing