contrib/intarray

Hi i found a rather strange behaviour in intarray.

When i dont use indices or use the intbig version it works as expected.
When i use gist__intbig_ops index, i returns something like "contained".
To illustrate: (it is on the test__int table provided in the package).

treetest=# DROP INDEX text_idx;
DROP
treetest=# select * from test__int where a= '{1}';
 a 
---
(0 rows)

treetest=# CREATE INDEX text_idx on test__int using gist ( a 
gist__intbig_ops );
CREATE
treetest=# select * from test__int where a= '{1}';
 a 
---
(0 rows)

treetest=# DROP INDEX text_idx;
DROP
treetest=# CREATE INDEX text_idx on test__int using gist ( a gist__int_ops 
);
CREATE
treetest=# select * from test__int where a= '{1}' limit 5;
        a        
-----------------
 {11,56,1}
 {34,1,39,16}
 {41,1,87,40,60}
 {41,64,10,1}
 {60,88,95,1}
(5 rows)

treetest=# 

When the gist__int_ops index is created the result is different

-- 
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@xxxxxxxxxxxxxxxxxxxxx
        mantzios@xxxxxxxxxxxxxxxxxxx


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx