1/* contrib/ltree/ltreetest.sql */
2
3-- Adjust this setting to control where the objects get created.
4SET search_path = public;
5
6CREATE TABLE test ( path ltree);
7INSERT INTO test VALUES ('Top');
8INSERT INTO test VALUES ('Top.Science');
9INSERT INTO test VALUES ('Top.Science.Astronomy');
10INSERT INTO test VALUES ('Top.Science.Astronomy.Astrophysics');
11INSERT INTO test VALUES ('Top.Science.Astronomy.Cosmology');
12INSERT INTO test VALUES ('Top.Hobbies');
13INSERT INTO test VALUES ('Top.Hobbies.Amateurs_Astronomy');
14INSERT INTO test VALUES ('Top.Collections');
15INSERT INTO test VALUES ('Top.Collections.Pictures');
16INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy');
17INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Stars');
18INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Galaxies');
19INSERT INTO test VALUES ('Top.Collections.Pictures.Astronomy.Astronauts');
20CREATE INDEX path_gist_idx ON test USING gist(path);
21CREATE INDEX path_idx ON test USING btree(path);
22