Styjun

What is the most efficient way to write 'for' loops in Matlab?

Why is it considered acid rain with pH <5.6?

Why is it "on the inside" and not "in the inside"?

Does Wolfram Mathworld make a mistake describing a discrete probability distribution with a probability density function?

Introducing Tetronogram!

Why does the Eurostar not show youth pricing?

How did the Axis intend to hold the Caucasus?

Why is the Apollo LEM ladder so far from the ground?

Why would a pilot use ailerons for countering asymmetric thrust in mid-flight?

Polyhedra, Polyhedron, Polytopes and Polygon

Is it error of law to judge on less relevant case law when there is much more relevant one?

Composing fill in the blanks

Do 3/8 (37.5%) of Quadratics Have No x-Intercepts?

When I cite content from a book, should I say "section 2.3.2.1 of book... " or "section 2.3.2.1 of `the` book ..."?

Telling manager project isn't worth the effort?

Strange pattern-matching: is it correct?

How likely is fragmentation on a table with 40000 products likely to affect performance

Why does Canada require mandatory bilingualism in a lot of federal government posts?

World of (nearly) identical snowflakes

How can I kill my goat?

Does dual boot harms laptop battery or reduces it's life?

How do you pronounce "Hain"?

Why force the nose of 737 Max down in the first place?

Copying an existing HTML page and use it, is that against any copyright law?

Using a recursive CTE, starting from children to parent to obtain a breadcrumb

Recursive CTE to find parent recordsrecursive cte - mark all leafsCTE in kdb recursive queryOracle CONNECT BY recursive child to parent query, include ultimate parent that self referencesMultiple recursive union all selects in a CTE SQL queryPostgres WITH RECURSIVE CTE: sorting/ordering children by popularity while retaining tree structure (parents always above children)recursive path aggregation and CTE query for top-down tree postgresCTE Query throws Recursion Exhausted errorPostgreSQL recursive parent/child queryHow to output nested json from nested CTE in postgresql using python?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I'm using a recursive query to get the descendants of a category, and the level:

id | name | parent_id

WITH RECURSIVE descendants(name, id, parent_id, lvl) AS (
 SELECT name, id, parent_id,0
 FROM categories WHERE id=2
 UNION
 SELECT c2.name, c2.id, c2.parent_id, lvl+1
 FROM categories AS c2
 INNER JOIN descendants AS d ON d.id = c2.parent_id
) SELECT
 *
FROM descendants order by lvl,id;

If I want to start from a children and get the parents, and reverse to use in a breadcrumb, how I should proceed.

I'm using Postgresql10 in combination with python.

python postgresql common-table-expression postgresql-10

share|improve this question

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges

add a comment | 

0

I'm using a recursive query to get the descendants of a category, and the level:

id | name | parent_id

WITH RECURSIVE descendants(name, id, parent_id, lvl) AS (
 SELECT name, id, parent_id,0
 FROM categories WHERE id=2
 UNION
 SELECT c2.name, c2.id, c2.parent_id, lvl+1
 FROM categories AS c2
 INNER JOIN descendants AS d ON d.id = c2.parent_id
) SELECT
 *
FROM descendants order by lvl,id;

If I want to start from a children and get the parents, and reverse to use in a breadcrumb, how I should proceed.

I'm using Postgresql10 in combination with python.

python postgresql common-table-expression postgresql-10

share|improve this question

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges

add a comment | 

I'm using a recursive query to get the descendants of a category, and the level:

id | name | parent_id

WITH RECURSIVE descendants(name, id, parent_id, lvl) AS (
 SELECT name, id, parent_id,0
 FROM categories WHERE id=2
 UNION
 SELECT c2.name, c2.id, c2.parent_id, lvl+1
 FROM categories AS c2
 INNER JOIN descendants AS d ON d.id = c2.parent_id
) SELECT
 *
FROM descendants order by lvl,id;

If I want to start from a children and get the parents, and reverse to use in a breadcrumb, how I should proceed.

I'm using Postgresql10 in combination with python.

python postgresql common-table-expression postgresql-10

share|improve this question

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges

WITH RECURSIVE descendants(name, id, parent_id, lvl) AS (
 SELECT name, id, parent_id,0
 FROM categories WHERE id=2
 UNION
 SELECT c2.name, c2.id, c2.parent_id, lvl+1
 FROM categories AS c2
 INNER JOIN descendants AS d ON d.id = c2.parent_id
) SELECT
 *
FROM descendants order by lvl,id;

share|improve this question

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges

share|improve this question

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges

asked Mar 26 at 19:35

user3541631user3541631

1,25933 gold badges1818 silver badges3939 bronze badges