From 42d069886f38687839388c615af608706508b557 Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Fri, 28 May 2004 10:43:32 +0000 Subject: New version. Add support for int2, int8, float4, float8, timestamp with/without time zone, time with/without time zone, date, interval, oid, money and macaddr, char, varchar/text, bytea, numeric, bit, varbit, inet/cidr types for GiST --- contrib/btree_gist/sql/btree_gist.sql | 66 ----------------------------------- 1 file changed, 66 deletions(-) delete mode 100644 contrib/btree_gist/sql/btree_gist.sql (limited to 'contrib/btree_gist/sql/btree_gist.sql') diff --git a/contrib/btree_gist/sql/btree_gist.sql b/contrib/btree_gist/sql/btree_gist.sql deleted file mode 100644 index b3f310a790c..00000000000 --- a/contrib/btree_gist/sql/btree_gist.sql +++ /dev/null @@ -1,66 +0,0 @@ --- --- first, define the datatype. Turn off echoing so that expected file --- does not depend on contents of btree_gist.sql. --- -\set ECHO none -\i btree_gist.sql -\set ECHO all - -CREATE TABLE int4tmp (b int4); - -\copy int4tmp from 'data/test_btree.data' - -CREATE TABLE int8tmp (b int8); - -\copy int8tmp from 'data/test_btree.data' - -CREATE TABLE float4tmp (b float4); - -\copy float4tmp from 'data/test_btree.data' - -CREATE TABLE float8tmp (b float8); - -\copy float8tmp from 'data/test_btree.data' - -CREATE TABLE tstmp ( t timestamp without time zone ); - -\copy tstmp from 'data/test_btree_ts.data' - --- without idx - -SELECT count(*) FROM int4tmp WHERE b <=10; - -SELECT count(*) FROM int8tmp WHERE b <=10; - -SELECT count(*) FROM float4tmp WHERE b <=10; - -SELECT count(*) FROM float8tmp WHERE b <=10; - -SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09'; - --- create idx - -CREATE INDEX aaaidx ON int4tmp USING gist ( b ); - -CREATE INDEX bbbidx ON int8tmp USING gist ( b ); - -CREATE INDEX cccidx ON float4tmp USING gist ( b ); - -CREATE INDEX dddidx ON float8tmp USING gist ( b ); - -CREATE INDEX tsidx ON tstmp USING gist ( t ); - ---with idx - -SET enable_seqscan=off; - -SELECT count(*) FROM int4tmp WHERE b <=10::int4; - -SELECT count(*) FROM int8tmp WHERE b <=10::int8; - -SELECT count(*) FROM float4tmp WHERE b <=10::float4; - -SELECT count(*) FROM float8tmp WHERE b <=10::float8; - -SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09'; - -- cgit v1.2.3