From 4bcb80a3e3112fb5969c3fbabaa5ecd3bd95f997 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Sat, 17 Mar 2001 21:59:42 +0000
Subject: Update contrib intarray to Jan 25 version.

---
 contrib/intarray/sql/_int.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'contrib/intarray/sql')

diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql
index f0176a06166..b23d406a6ab 100644
--- a/contrib/intarray/sql/_int.sql
+++ b/contrib/intarray/sql/_int.sql
@@ -13,3 +13,14 @@ CREATE TABLE test__int( a int[] );
 SELECT count(*) from test__int WHERE a && '{23,50}';
 SELECT count(*) from test__int WHERE a @ '{23,50}';
 
+CREATE INDEX text_idx on test__int using gist ( a gist__int_ops ) with ( islossy );
+
+SELECT count(*) from test__int WHERE a && '{23,50}';
+SELECT count(*) from test__int WHERE a @ '{23,50}';
+
+drop index text_idx;
+CREATE INDEX text_idx on test__int using gist ( a gist__intbig_ops ) with ( islossy );
+
+SELECT count(*) from test__int WHERE a && '{23,50}';
+SELECT count(*) from test__int WHERE a @ '{23,50}';
+
-- 
cgit v1.2.3