Re: Searching for pgweb

I think so. For example:

search=# SELECT count(*) FROM webpages WHERE suburl LIKE '/docs/current/%'
AND fti @@ plainto_tsquery('create index');
count
-------
342
(1 row)

search=# SELECT count(*) FROM webpages WHERE suburl LIKE '/docs/current/%'
AND fti @@ phraseto_tsquery('create index');
count
-------
106
(1 row)

But yes, that is kind of the core of the question.

I don't think it needs any special user docs -- it's not like we have
documented how it works now, it's supposed to "just work".

//Magnus

On Thu, Mar 23, 2017 at 9:11 AM, Peter van Hardenberg <pvh(at)pvh(dot)ca> wrote:

> Ok, I'll ask the silly questions: Will it actually give better results?
> Does it need user documentation added beyond just changing the query?
>
> On Wed, Mar 22, 2017 at 11:20 AM, Christophe Pettus <xof(at)thebuild(dot)com>
> wrote:
>
>>
>> > On Mar 22, 2017, at 09:51, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> > Should we consider switching that to phraseto_tsquery() now that we
>> have phrase searching?
>>
>> +1.
>>
>> --
>> -- Christophe Pettus
>> xof(at)thebuild(dot)com
>>
>>
>>