PolarDB-for-PostgreSQL

1
/* contrib/ltree/ltreetest.sql */
2

3
-- Adjust this setting to control where the objects get created.
4
SET search_path = public;
5

6
CREATE TABLE test ( path ltree);
7
INSERT INTO test VALUES ('Top');
8
INSERT INTO test VALUES ('Top.Science');
9
INSERT INTO test VALUES ('Top.Science.Astronomy');
10
INSERT INTO test VALUES ('Top.Science.Astronomy.Astrophysics');
11
INSERT INTO test VALUES ('Top.Science.Astronomy.Cosmology');
12
INSERT INTO test VALUES ('Top.Hobbies');
13
INSERT INTO test VALUES ('Top.Hobbies.Amateurs_Astronomy');
14
INSERT INTO test VALUES ('Top.Collections');
15
INSERT INTO test VALUES ('Top.Collections.Pictures');
16
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy');
17
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Stars');
18
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Galaxies');
19
INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Astronauts');
20
CREATE INDEX path_gist_idx ON test USING gist(path);
21
CREATE INDEX path_idx ON test USING btree(path);
22