Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH RECURSIVE CategoryTree("id", "categoryName", "prevId", "level") AS (
- SELECT public."productCategories"."id", public."productCategories"."categoryName", public."productCategories"."prevId", 1 AS level
- FROM public."productCategories"
- WHERE id = 13
- UNION ALL
- select categories."id", categories."categoryName", categories."prevId", categoryTree."level" + 1
- FROM public."productCategories" categories
- JOIN categoryTree ON categories."id" = categoryTree."prevId"
- )
- SELECT array_to_string(array_agg(distinct "id"), '/') as "categoryTreeId", string_agg("categoryName", '/') as "categoryTreeName"
- FROM (
- SELECT "id", "categoryName", "level"
- FROM categoryTree
- ORDER BY "level" DESC
- ) as result
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement