Thank you Emmanuel. Can you tell me more about it ? I have spent so much time back and forth deciding on how and what should handle my search. I must say, I remember that his was a possibility now early in my development but none in the grails community have mentioned it as an option when I have brought up the search discussion... How powerful is it? Compared to lucene ? (ooh now I see that its built on lucene)... but how come no one have mentioned it in grails... does this come with the normal grails/hibernate distro ? Or is it like a plugin ?
May main reason for going for postgres Tsearch is the possibilty to mix fulltext and relational matching... I guess this is not a problem with Hibernate search ? Is there any drawbacks I should know about ? Thank you / Moe On Mon, Jan 5, 2009 at 9:06 PM, Emmanuel Bernard <emman...@hibernate.org>wrote: > 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
