Feature: Use Postgres LTREE for groups hierarchy

[arvindh123]

Is your feature request related to a problem? Please describe.

Reference: https://github.com/absmach/magistrala/issues/1980

Describe the feature you are requesting, as well as the possible use case(s) for it.

Implmentation

• Create Extension LTREE in postgres
• Add a column with name path and type as LTREE
• While inserting new row
  If the inserting new row have no parent . path column should have value of id
  If the inserting new row have parent, Get the path column should have parent path + .+ id
• Retrieve Ancestors / Parents and Descendants / Children by using the below given in Add LTREE Path in Groups #1980

Indicate the importance of this feature to you.

Should-have

Anything else?

No response

[dborovcanin]

This is in progress in https://github.com/absmach/magistrala/pull/2409.

[dborovcanin]

I am closing as a duplicate of #1980.