diff options
Diffstat (limited to 'contrib/ltree/ltreetest.sql')
-rw-r--r-- | contrib/ltree/ltreetest.sql | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/contrib/ltree/ltreetest.sql b/contrib/ltree/ltreetest.sql index 0dd6eaa63d0..eea5c475ee9 100644 --- a/contrib/ltree/ltreetest.sql +++ b/contrib/ltree/ltreetest.sql @@ -1,16 +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); +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); |