How can I match things like "C#" and "C++" in PostgreSQL's full text search?

Question

Unfortunately the parser discards all punctuation, so that 'C', 'C++' and 'C#' all end up as 'c'.

The only thing I can think of (aside from replacing the parser which isn't really an option right now), would be to implement my own miniature synonym dictionary before using any of the FTS functions, replacing "C++" with "Cpp" and "C#" with "Csharp" either in the application or in the queries, for example. Is there any way to do this with FTS functions/features?

Answer 1

Transliterate any relevant punctuation to words. C++ -> Cplusplus, C# -> Csharp, PL/SQL -> PLslashSQL