Postgresql search does not find exact matches

[doits]

Describe the bug

When I enable postgresql search ("Database - postgresql" at /a/search) the search does not find exact matches. For example:

1. Search for Hom - it correctly finds the home page

2. Search for Home - no results

(The "Did you mean" suggestion is pointless here, too, since this is my exact search query.)

It seams to be the case for every possible match, not only page titles. E.g. searching for a word on a page only finds that page when the word is not complete. (E.g. I have the heading Users on a page: Searching for User finds it, but searching for Users not.)

Host Info (please complete the following information):

• OS: Ubuntu 18.04
• Wiki.js version: 2.0.0-beta.208
• Database engine: postgres 10.4

[ethanmdavidson]

I seem to be having the exact opposite issue. I have a page with title 'Home' which shows up when the search term is 'home' but not when it's 'hom'. This also occurs for text in page bodies.

• OS: CentOS 7.6
• WikiJS version: 2.0.0-beta.303
• Database engine: postgres 11.5
• Search Provider: Database - PostgreSQL

When using the "Database - Basic" search provider, the search works as expected.

[vabene1111]

I am having the exakt same problem as descriped by OP.

System: Docker Container (Linux)
WikiJs Version: 2.0.12
PG Version: 11.6
Node JS Version: 10.16.3
Search Provider: Database - PostgreSQL (with german dictionary)

Here are some screenshots for further illustration, i have also tried different capitilitation but that does not change anything.

[vabene1111]

The Specific search shown above in the screenshots works but its still rather buggy overall (both using the simple and the according german dict.

other words, even tough contained completly in the description dont appear at all