From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- contrib/ltree/ltreetest.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 contrib/ltree/ltreetest.sql (limited to 'contrib/ltree/ltreetest.sql') diff --git a/contrib/ltree/ltreetest.sql b/contrib/ltree/ltreetest.sql new file mode 100644 index 0000000..d6996ca --- /dev/null +++ b/contrib/ltree/ltreetest.sql @@ -0,0 +1,21 @@ +/* contrib/ltree/ltreetest.sql */ + +-- Adjust this setting to control where the objects get created. +SET search_path = public; + +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); -- cgit v1.2.3