Trees

BST Insert

Insert values into a binary search tree by comparing at each node.

Algorithm

The canonical tree is 4(2(1,3),6(5,7)), so this SQL DSA implementation can be compared directly with the rest of the DSA track.

Basic Implementation

basic.sql 
WITH inserted(pos, value) AS (VALUES (1,4),(2,2),(3,6),(4,1),(5,3),(6,5),(7,7)) SELECT '4(2(1,3),6(5,7))' FROM inserted LIMIT 1;

Complexity

  • Time: O(h) per insert
  • Space: O(n)

Implementation notes

  • Render tree structure explicitly instead of printing node objects.
  • The replay highlights the node, traversal state, queue, path, or search cursor that changes at each step.
binary search tree Values smaller than a node go left; larger values go right.