On Sun, 19 Dec 2010, Glenn Maynard wrote:
2010/12/19 Oleg Bartunov o...@sai.msu.su:
You might be interested in http://www.sai.msu.su/~megera/wiki/2009-08-12
Thanks, that looks pretty much like what I had in mind. Hopefully
that'll get merged for 9.0+1; phrases are a major part of all text
I guess no response means it's not possible. I ended up doing a
manual substring match for quoted strings, but that's a poor hack.
Maybe I'll take a poke at implementing something like
tsvector_contains_phrase; it seems like a natural extension of what's
in there now.
On Mon, Nov 1, 2010 at
You might be interested in http://www.sai.msu.su/~megera/wiki/2009-08-12
Oleg
On Sun, 19 Dec 2010, Glenn Maynard wrote:
I guess no response means it's not possible. I ended up doing a
manual substring match for quoted strings, but that's a poor hack.
Maybe I'll take a poke at implementing
2010/12/19 Oleg Bartunov o...@sai.msu.su:
You might be interested in http://www.sai.msu.su/~megera/wiki/2009-08-12
Thanks, that looks pretty much like what I had in mind. Hopefully
that'll get merged for 9.0+1; phrases are a major part of all text
searches.
--
Glenn Maynard
--
Sent via
How are adjacent word searches handled with FTS? tsquery doesn't do
this, so I assume this has to be done as a separate filter step, eg.:
# large house sales
SELECT * FROM data WHERE fts @@ to_tsquery('large house sales')
AND tsvector_contains_phrase(fts, to_tsvector('large house')));
to