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

1 files changed, 0 insertions, 102 deletions

diff --git a/contrib/btree_gist/expected/btree_gist.out b/contrib/btree_gist/expected/btree_gist.out
deleted file mode 100644
index a1cb6102ab6..00000000000
--- a/contrib/btree_gist/expected/btree_gist.out
+++ /dev/null
@@ -1,102 +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
-psql:btree_gist.sql:8: NOTICE:  type "int2key" is not yet defined
-DETAIL:  Creating a shell type definition.
-psql:btree_gist.sql:13: NOTICE:  argument type int2key is only a shell
-psql:btree_gist.sql:25: NOTICE:  type "int4key" is not yet defined
-DETAIL:  Creating a shell type definition.
-psql:btree_gist.sql:30: NOTICE:  argument type int4key is only a shell
-psql:btree_gist.sql:42: NOTICE:  type "int8key" is not yet defined
-DETAIL:  Creating a shell type definition.
-psql:btree_gist.sql:47: NOTICE:  argument type int8key is only a shell
-psql:btree_gist.sql:59: NOTICE:  type "float4key" is not yet defined
-DETAIL:  Creating a shell type definition.
-psql:btree_gist.sql:64: NOTICE:  argument type float4key is only a shell
-psql:btree_gist.sql:77: NOTICE:  type "float8key" is not yet defined
-DETAIL:  Creating a shell type definition.
-psql:btree_gist.sql:82: NOTICE:  argument type float8key is only a shell
-psql:btree_gist.sql:392: NOTICE:  type "tskey" is not yet defined
-DETAIL:  Creating a shell type definition.
-psql:btree_gist.sql:397: NOTICE:  argument type tskey is only a shell
-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;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM int8tmp WHERE b <=10;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM float4tmp WHERE b <=10;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM float8tmp WHERE b <=10;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09';
- count 
--------
-    66
-(1 row)
-
--- 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;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM int8tmp WHERE b <=10::int8;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM float4tmp WHERE b <=10::float4;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM float8tmp WHERE b <=10::float8;
- count 
--------
-    11
-(1 row)
-
-SELECT count(*) FROM tstmp WHERE t < '2001-05-29 08:33:09';
- count 
--------
-    66
-(1 row)
-