Re: [PERFORM] int4 in a GiST index

2004-11-10 Thread Mike Rylander
On Wed, 10 Nov 2004 18:50:28 -0800 (PST), George Essig <[EMAIL PROTECTED]> wrote: > Mike Rylander wrote: > > > I want to create a multi-column index across the tsvector and classification > > columns as that should help with selectivity. But because there is no > > GiST opclass for INT4 the index

Re: [PERFORM] int4 in a GiST index

2004-11-10 Thread George Essig
Mike Rylander wrote: > I want to create a multi-column index across the tsvector and classification > columns as that should help with selectivity. But because there is no > GiST opclass for INT4 the index creation complains thusly: Install contrib/btree_gist along with contrib/tsearch2 to creat

[PERFORM] int4 in a GiST index

2004-11-10 Thread Mike Rylander
Hello all, I am using tsearch2 to (imagine this... :) index a text field. There is also a, for lack of a better name, "classification" field called 'field' that will be used to group certain rows together. CREATE TABLE biblio.metarecord_field_entry ( record BIGINT REFERENCES bi