cojack

ltree=> SELECT * FROM tree ORDER BY "categoryPath";
 idCategory |         categoryPath
------------+------------------------------
         27 | 1.Top
         28 | 1.Top.1.Science
         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
         40 | 1.Top.1.Science.5.Archeology
         29 | 1.Top.2.Hobby
         35 | 1.Top.2.Hobby.1.Fishing
         36 | 1.Top.2.Hobby.2.Football
         41 | 1.Top.2.Hobby.3.Swimming
         45 | 1.Top.2.Hobby.4.Climbing
         30 | 1.Top.3.Colors
         37 | 1.Top.3.Colors.1.Black
         38 | 1.Top.3.Colors.2.Red
         39 | 1.Top.3.Colors.3.Blue
         42 | 1.Top.3.Colors.4.Gray
         43 | 1.Top.3.Colors.5.Purple
         44 | 1.Top.3.Colors.6.Brown