Hey guys I am trying to use full text search with postgres, but it only seems to work for entire words. Is it also possible to return partial results? Like fuzzy search?

Hey Julian 👋 Do you have any particular text search use case which you can’t achieve? Here’s an example of what can be achieved through full text search in PostgreSQL as of now. We have an existing Feature Request to support PostgreSQL trigrams. If this is what you need can you please leave a 👍 to the request so that our teams could prioritise it.

From what I see so far, this only works if it contains the entire word, is that correct? So if I have a product with name "dogfood", I need to type "dogfood" in order to return the product from the database, and "dog" wouldn't return anything? At least that's what I get right now

I see, we do have support for

contains

,

startsWith

and

endsWith

clause support as mentioned here. I think that should cover some of the use cases for you

Ah okay cool that's exactly what I need

Full text search is to support these native Postgres Text Search functions which are somewhat different, you can read bout them here - https://www.postgresql.org/docs/12/functions-textsearch.html

Okay cool, thanks!

Glad to hear that you are having a good experience! 😃 🙌