how to add @ to postgres hibernate dialect?
you can find it in this link, that link will guide you to :
- recognize that SQLFunctions have to return a value and when used inHQL must be in an expression form (e.g., fts(body, 'dog') = true --fts(body, 'dog') won't work in HQL)
- create a Hibernate SQLFunction for PG FTS; and
- remember that the expression "to_tsvector(body) @@ to_tsquery('dog')"evaluates to a boolean