Michael Fuhr <[EMAIL PROTECTED]> writes:
> Here's a complete test case:
> CREATE TABLE foo (a integer[]);
> INSERT INTO foo (a)
> SELECT array[random() * 10, random() * 10, random() * 10]
> FROM generate_series(1, 24);
> CREATE INDEX foo_a_idx ON foo USING gist (a gist__int_ops);
> SET enable_seqscan TO off;
> SELECT f1.a & f2.a FROM foo f1, foo f2 WHERE f1.a && f2.a;
This seems to bear out the concern expressed at _int_gist.c line 44:
/* XXX are we sure it's safe to scribble on the query object here? */
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
