Re: Term positions in GIN fulltext index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yoann Moreau <yoann(dot)moreau(at)univ-avignon(dot)fr>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Term positions in GIN fulltext index
Date: 2011-11-03 19:01:29
Message-ID: 7024.1320346889@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Yoann Moreau <yoann(dot)moreau(at)univ-avignon(dot)fr> writes:
> I'm using a GIN index for a text column on a big table. I use it to rank
> the rows, but I also need to get the term positions for each document of a
> subset of documents for one or more terms. I suppose these positions are stored
> in the index as the to_tsvector shows them : 'lexeme':{positions}

I'm pretty sure that a GIN index on tsvector does *not* store positions
--- it only knows about the strings. Don't know one way or the other
about GIST.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marcin Mańk 2011-11-03 19:34:15 Re: Term positions in GIN fulltext index
Previous Message Florian Pflug 2011-11-03 18:20:58 Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)