Add tests, make complile for different versions (8.3+)

[gevel.git] / sql / gevel.sql

diff --git a/sql/gevel.sql b/sql/gevel.sql
new file mode 100644 (file)
index 0000000..6024eae
--- /dev/null
+++ b/sql/gevel.sql
@@ -0,0 +1,16 @@
+SET client_min_messages = warning;
+\set ECHO none
+\i gevel.sql
+\set ECHO all
+RESET client_min_messages;
+
+
+CREATE TABLE gevelt ( t box );
+\copy gevelt from 'data/rect.data'
+
+CREATE INDEX gist_idx ON gevelt USING gist ( t );
+
+--GiST
+SELECT gist_stat('gist_idx');
+SELECT gist_tree('gist_idx');
+SELECT * FROM gist_print('gist_idx') as t(level int, valid bool, a box) where level=1;