[Hibernate] Postgres, Tsearch2 and Hibernate ? HQL or stick with SQL ?

[Mohamed <moh...@gm...>]

Hi, I am new to this list. I have been using Hibernate through Grails and
Gorm for a while now and I just switched my DB to Postgres from MySql to
take advantage of the fulltext support in PostgresSql.
I was wondering if it is possible and if so, how to write HQL queries that
involves the TSearch2.

An Sql query would look something like this :

select title from someTable where

to_tsvector('english', description) @@ to_tsquery('english', 'car') and
where name = 'carl';


Where the fulltext search is this part : to_tsvector('english', description)
@@ to_tsquery('english', 'car')


How does this look like in HQL ? Is this possible to use a DB special
features with Hibernate ?

/ Moe