I try to use full text search like
$STM = $PDO->prepare('SELECT title FROM zz_ad.advs WHERE to_tsvector(title) @@ to_tsquery(:str)');
$STM->execute(['str' => 'Hi!']);
$STM->fetchAll();
As a result i have: ERROR: syntax error in tsquery: "Hi!"
If i try without a "!" its work!
For the documentation:
A tsquery value stores lexemes that are to be searched for, and combines them honoring the Boolean operators & (AND), | (OR), and ! (NOT). Parentheses can be used to enforce grouping of the operators.
'Hi!' is not a valid lexeme. 'Hi' is.