I'm a noob in the recursive domain in that I understand the syntax but I'm unable to apply it to my current problem. I'm using Postgre SQL. I have a product_id 'ABC123' that has a parent category 'FG_ACC_CA', which itself…
From "Montreal" as the origin point, I'm trying to find the shortest path to go to another city. But I'm having difficulty when a city is looped. demo at db<>fiddle create table flights(id,src,dst,cost)as values (0,'Montreal','NY', 742.94) ,(1,'Montreal','Detroit', 362.47) ,(2,'NY', 'Detroit',…
I need to insert data into new table person_department using recursion. My tables for now: person id group_id 800 10 805 21 department id name group_id parent_id 1 ABC 10 5 2 TY 11 5 5 OOO null 9 6…
we want to "fill in the gaps" of the record_ids and fill in missing values with the most recent available value. If there is no value available, use the first available value instead. The result should look like: category record_id…
id_start id_end 1 2 2 3 3 4 I want to collect elements who are "connected" like [1, 2, 3, 4]. (in an array for example) I tried a recursive query like: WITH RECURSIVE q_rec AS ( SELECT id_start, id_end…
aid bid 1 2 1 3 2 3 3 4 5 6 7 8 8 10 8 9 I would like to extarct the hierarchy linkage for aid and bid. No need to show each path, any id should show…
Table "skus": plant_species_ids 1,2,3,2,3,1 Table "plant_species" id name 1 Plant 1 2 Plant 2 3 Plant 3 The relevant part of my MySQL code: ... GROUP_CONCAT(plant_species.name SEPARATOR ', ') as plant_species_names ... LEFT JOIN plant_species ON FIND_IN_SET(plant_species.id, skus.plant_species_ids) > 0…
Situation: Imagine some script that, upon completion, inserts the current timestamp and some other data into a MySQL table. It's executed every thirty minutes, sometimes not at all, leaving gaps in the data. Goal: Have a query that fetches all…
hello i have table profile that has many attributs, and the profile has on parent but the parent can have a parent etc.. I want to get all the list of the attributs(even the attributs of the parents) i wrote…
I have a representation of a (binary) tree as a table in PostgreSQL. Each row is a node of the tree and each row has a parent column and a color. The nodes at he leaves of the tree have…