Hi can make it more usable by correcting the mistakes, your final solution is actually storing parentid as root for all rows. also you are assuning page table is created and select query is looking for parent not parentid = 3.
And insert for ltree table has a duplicate entry for id. Please check final solution and correct parent_id
Hi can make it more usable by correcting the mistakes, your final solution is actually storing parentid as root for all rows. also you are assuning page table is created and select query is looking for parent not parentid = 3.
And insert for ltree table has a duplicate entry for id. Please check final solution and correct parent_id