com.communote.server.core.database.hibernate

Class PostgreSQLFulltextFunction

java.lang.Object

com.communote.server.core.database.hibernate.FulltextSQLFunction

com.communote.server.core.database.hibernate.PostgreSQLFulltextFunction

All Implemented Interfaces:

org.hibernate.dialect.function.SQLFunction

public class PostgreSQLFulltextFunction
extends FulltextSQLFunction

For creating an index on PostgreSQL use: CREATE INDEX core_content_full_en_idx ON core_content USING gin(to_tsvector('english', content)); CREATE INDEX core_content_full_de_idx ON core_content USING gin(to_tsvector('german', content));

Author:

Communote GmbH - http://www.communote.com/

Constructor Summary

Constructors

Constructor and Description
PostgreSQLFulltextFunction(String textSearchConfigurationName) See http://www.postgresql.org/docs/9.1/static/sql-createtsconfig.html or http://www.postgresql.org/docs/9.1/static/textsearch.html for more information

Method Summary

Modifier and Type	Method and Description
String	render(org.hibernate.type.Type firstArgumentType, List arguments, org.hibernate.engine.SessionFactoryImplementor factory)

Methods inherited from class com.communote.server.core.database.hibernate.FulltextSQLFunction

getReturnType, hasArguments, hasParenthesesIfNoArguments

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgreSQLFulltextFunction

public PostgreSQLFulltextFunction(String textSearchConfigurationName)

See http://www.postgresql.org/docs/9.1/static/sql-createtsconfig.html or http://www.postgresql.org/docs/9.1/static/textsearch.html for more information

Parameters:

textSearchConfigurationName - name of the text search configuration to be used, e.g. simple or english (without any quotes)

Method Detail

render

public String render(org.hibernate.type.Type firstArgumentType,
                     List arguments,
                     org.hibernate.engine.SessionFactoryImplementor factory)