It is not possible. But I encourage you to look at Hibernate Search
for your full text needs. It does not rely on your database
capabilities and works as expected in Grails.
Also, please ask your questions at http://forum.hibernate.org
Emmanuel
On Jan 5, 2009, at 13:30, Mohamed wrote:
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
------------------------------------------------------------------------------
_______________________________________________
hibernate-devel mailing list
hibernate-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
