how to add @ to postgres hibernate dialect? how to add @ to postgres hibernate dialect? postgresql postgresql

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