PostgreSQL has a very complex operator parsing rule:

1. Any string consisting of + - * / < > = ~ ! @ # % ^ & | ` ? characters with a length of less than or equal to 63 is recognized as an operator, but does not contain -- and /*, which are always recognized as comments.
2. Operators cannot end with + and - unless it contains at least one ~ ! @ # % ^ & | ` ? character.

I can't think of any way to handle comments that doesn't work the way I want, even adjusting the priority. Does anyone have any experience with this that I can refer to?