Add ltree data type to contrib, from Teodor Sigaev and Oleg Bartunov.

1 files changed, 16 insertions, 0 deletions

diff --git a/contrib/ltree/ltreetest.sql b/contrib/ltree/ltreetest.sql
new file mode 100644
index 00000000000..0dd6eaa63d0
--- /dev/null
+++ b/contrib/ltree/ltreetest.sql
@@ -0,0 +1,16 @@
+create table test ( path ltree);
+insert into test values ('Top');
+insert into test values ('Top.Science');
+insert into test values ('Top.Science.Astronomy');
+insert into test values ('Top.Science.Astronomy.Astrophysics');
+insert into test values ('Top.Science.Astronomy.Cosmology');
+insert into test values ('Top.Hobbies');
+insert into test values ('Top.Hobbies.Amateurs_Astronomy');
+insert into test values ('Top.Collections');
+insert into test values ('Top.Collections.Pictures');
+insert into test values ('Top.Collections.Pictures.Astronomy');
+insert into test values ('Top.Collections.Pictures.Astronomy.Stars');
+insert into test values ('Top.Collections.Pictures.Astronomy.Galaxies');
+insert into test values ('Top.Collections.Pictures.Astronomy.Astronauts');
+create index path_gist_idx on test using gist(path);
+create index path_idx on test using btree(path);