Re: Efficient intersect operation (Full Text Search)

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Efficient intersect operation (Full Text Search)
Date: 2010-04-27 09:33:41
Message-ID: j2pab1ea6541004270233zec1ed24cs6f11a81341698994@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Apr 14, 2010 at 11:39 AM, Allan Kamau <kamauallan(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-04-27 09:57:10 Re: Unable to run createlang (or psql for that matter)
Previous Message Rod 2010-04-27 09:23:31 Re: Storing many big files in database- should I do it?