Re: Efficient intersect operation (Full Text Search) - Mailing list pgsql-general

From Allan Kamau
Subject Re: Efficient intersect operation (Full Text Search)
Date
Msg-id j2pab1ea6541004270233zec1ed24cs6f11a81341698994@mail.gmail.com
Whole thread Raw
In response to Efficient intersect operation (Full Text Search)  (Allan Kamau <kamauallan@gmail.com>)
List pgsql-general
On Wed, Apr 14, 2010 at 11:39 AM, Allan Kamau <kamauallan@gmail.com> wrote:
> I have a brief question - I can provide more information if it is not clear.
>
> I would like to perform pairwise intersect operations between several
> pairs of sets (where a set is a list or vector of labels), I have many
> such pairs of sets and the counts of their elements may vary greatly.
>
> Is there a way to perform to "AND" two tsvectors and get the resulting
> intersect as another tsvector?
>
>
> Allan.
>

To refine the above question, is there a way to intersect two
tsvectors? In short I would like to intersect two documents.

Allan.

pgsql-general by date:

Previous
From:
Date:
Subject: Re: PostgreSQL Performance issue
Next
From: John Gage
Date:
Subject: Re: Unable to run createlang (or psql for that matter)