Re: contrib/intarray - Mailing list pgsql-sql

From Oleg Bartunov
Subject Re: contrib/intarray
Date
Msg-id Pine.GSO.4.44.0205311408230.17688-100000@ra.sai.msu.su
Whole thread Raw
In response to contrib/intarray  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
There is probably a bug in gist__int_ops ( 'contained' ops used instead of '=')
We'll submit fix later

Oleg
On Fri, 31 May 2002, Achilleus Mantzios wrote:

>
> 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
>
>
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



pgsql-sql by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: question on JOIN and WHERE clause
Next
From: Achilleus Mantzios
Date:
Subject: http://www.postgresql.org/idocs/ PROBLEM!