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

[Emmanuel B. <emm...@hi...>]

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
> hib...@li...
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel