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