postgres full text search like operator

Question

what is the query to use to search for text that matches the like operator.

I am asking about full text search query, which is of the form

 SELECT * FROM eventlogging WHERE description_tsv @@ plainto_tsquery('mess');   

I want results with "message" as well but right not it does not return anything

Answer 1

If I read the description in the manual correctly, you'll need to use to_tsquery() instead of plainto_tsquery together with a wildcard to allow prefix matching:

SELECT * 
FROM eventlogging 
WHERE description_tsv @@ to_tsquery('mess:*');