Re: [GENERAL] FTS phrase searches

2010-12-20 Thread Oleg Bartunov
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

Re: [GENERAL] FTS phrase searches

2010-12-19 Thread Glenn Maynard
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

Re: [GENERAL] FTS phrase searches

2010-12-19 Thread Oleg Bartunov
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

Re: [GENERAL] FTS phrase searches

2010-12-19 Thread Glenn Maynard
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

[GENERAL] FTS phrase searches

2010-11-01 Thread Glenn Maynard
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