From 42d069886f38687839388c615af608706508b557 Mon Sep 17 00:00:00 2001
From: Teodor Sigaev <teodor@sigaev.ru>
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

