postgresql_code

Aug 17, 2024

d539998 · Aug 17, 2024

Name	Name	Last commit message	Last commit date
parent directory ..
01-create-table.sql	01-create-table.sql	add code	Oct 8, 2023
02-create-nodes.sql	02-create-nodes.sql	add code	Oct 8, 2023
03-finding-root-node.sql	03-finding-root-node.sql	add code	Oct 8, 2023
04-finding-the-immediate-children-of-a-node.sql	04-finding-the-immediate-children-of-a-node.sql	add code	Oct 8, 2023
05-find-how-many-immediate-children-a-node-has.sql	05-find-how-many-immediate-children-a-node-has.sql	add code	Oct 8, 2023
06-finding-the-leaf-nodes-sub-query.sql	06-finding-the-leaf-nodes-sub-query.sql	add code	Oct 8, 2023
07-finding-the-leaf-nodes-left-join.sql	07-finding-the-leaf-nodes-left-join.sql	add code	Oct 8, 2023
08-find-full-path.sql	08-find-full-path.sql	add code	Oct 8, 2023
09-find-full-path-as-list-with-depth.sql	09-find-full-path-as-list-with-depth.sql	add code	Oct 8, 2023
10-query-a-sub-tree-top-bttom.sql	10-query-a-sub-tree-top-bttom.sql	add code	Oct 8, 2023
11-query-a-sub-tree-bottom-up.sql	11-query-a-sub-tree-bottom-up.sql	add code	Oct 8, 2023
12-get-the-row-number-for-each-group.sql	12-get-the-row-number-for-each-group.sql	Create 12-get-the-row-number-for-each-group.sql	Aug 17, 2024
README.md	README.md	add links to code	Oct 8, 2023

README.md

The tree from the videos:

stateDiagram-v2
    Fruits --> Apple
    Fruits --> Mango
    Apple --> Green Apple
    Apple --> Yellow Apple
    Apple --> Red Apple

Here you can find the SQL code for the nested sets model written in PostgreSQL 13.3-1.pgdg100+1