Posts by Isaque Neves • 1 point
2 posts
-
0
votes1
answer147
viewsA: Recursive query in Postgresql to create a menu tree
I have a solution, I don’t know if it’s the best, but it’s working like this, if anyone has a better idea, you can suggest WITH RECURSIVE location_with_level AS ( ( SELECT menus.*, 0 AS level FROM…
mysqlanswered Isaque Neves 1 -
0
votes1
answer147
viewsQ: Recursive query in Postgresql to create a menu tree
How to create a json from a hierarchical SQL structure with Postgresql 12? I need to create a menu as the image below. This menu is already working, but, the solution I am using is not very…
mysqlasked Isaque Neves 1