pstgres ltree example

m6hw1_schema_sandbox.sql

DROP TABLE IF EXISTS KeywordLtreeSandbox CASCADE;
CREATE TABLE KeywordLtreeSandbox(
  id INT PRIMARY KEY,
  value TEXT,
  path ltree
);

INSERT INTO KeywordLtreeSandbox(id, value, path) VALUES
  (0, 'A', '')
, (1, 'B', '1')
, (2, 'C', '2')
, (3, 'D', '1.3')
, (4, 'E', '1.4')
, (5, 'F', '1.5')
, (6, 'G', '2.6')
, (7, 'H', '2.7')
;