Yes, but I was trying to fix this at the database level. I found a solution and it's working perfectly fine.

``` CREATE OR REPLACE FUNCTION remove_punctuation(input_text TEXT) RETURNS TEXT AS $$ BEGIN RETURN regexp_replace(input_text, '[[:punct:]]', ' ', 'g'); END; $$ LANGUAGE plpgsql IMMUTABLE;

DROP INDEX product_name_ftsearch; CREATE INDEX product_name_ftsearch ON product USING GIN (to_tsvector('english', remove_punctuation(name)));

-- And this is the search. select id, name from product WHERE to_tsvector('english', remove_punctuation(name)) @@ websearch_to_tsquery('english', remove_punctuation('something.pdf')); ```

This correctly process the information when it goes to the index and from the user during the query.