Question : Consider the following table and data (fiddle available here): CREATE TABLE test ( id INTEGER NOT NULL AUTO_INCREMENT […]
Tag: recursive
Can performance be improved by breaking databases up? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Postgres plpgsql: Is a view better than a select query in a plpgsql function
Question : I have a recursive query to the general effect of: WITH RECURSIVE text1 (selfid, parentid, text) AS ( […]
Which columns need index in recursive table and soft delete
Question : I have a Category table like below : I have a recursive relationship on this Category table. I […]
Query to find circular references
Question : I have two tables ID Task 1 1 2 2 3 3 4 4 Col1 depend 2 3 […]
Define recursive composite types
Question : Is it possible to define recursive composite types in Postgres 13? create type “t” as ( “a” int, […]
Recursive CTE to find Total for all children
Question : Here is an assembly tree that I want to search using a recursive T-SQL Query (presumably CTE) with […]
Postgresql split single row into multiple rows based on date [duplicate]
Question : This question already has answers here: PostgreSQL: Generate a series of dates for each group in a table […]
Count the nodes in a binary tree structure
Question : I need to count the left and right nodes in a binary tree structure (output grouped by joiningDate), […]
Finding the current prices for n Fuelstations at a certain point in time
Question : I have a Table where price information is stored in with approx 13 million rows stored in a […]