CODEWITHSUNDEEP
laravelpostgresqlsearchlaravel-scout
Aleks
Aleks

Reputation: 147

What difference between tsquery and phrasequery in Laravel Scout with postgresql driver?

Please, tell me what difference between tsquery and phrasequery. I asked because when i tested my code with different configuration - was the same result.

I have this configuration for scout with pgsql driver,

enter image description here

and in search_using parameter we can choose what type of search i want to use. So when I tried tsquery and do that $results = User::search('Tom Scoat')->get(); it is crashing.

When i change type to phrasequery it just return empty array. And I can't understand how scout with pgsql driver is working in general. Because it does not search when the word is not exactly the same. For example when $results = User::search('Scoa')->get(); it return empty array.

Upvotes: 1

Views: 185

Answers (1)

jjanes
jjanes

Reputation: 44373

phrasequery requires the queried terms be adjacent to each other, rather than merely present in the same document.

If you want help testing this, you would need to show us your tests.

Upvotes: 0

Related Questions