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
------------------------------------------------------------------------------
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
