Package org.hibernate.dialect.function

<p> A framework for defining database-specific SQL functions that are available via the dialect.

See: Description

Interface Summary

Interface	Description
SQLFunction	Provides support routines for the HQL functions as used in the various SQL Dialects

Class Summary

Class	Description
AbstractAnsiTrimEmulationFunction	A SQLFunction providing support for implementing TRIM functionality (as defined by both the ANSI SQL and JPA specs) in cases where the dialect may not support the full <tt>trim</tt> function itself.
AnsiTrimEmulationFunction	A SQLFunction implementation that emulates the ANSI SQL trim function on dialects which do not support the full definition.
AnsiTrimFunction	Defines support for rendering according to ANSI SQL <tt>TRIM</tt> function specification.
AvgWithArgumentCastFunction	Some databases strictly return the type of the of the aggregation value for <tt>AVG</tt> which is problematic in the case of averaging integers because the decimals will be dropped.
CastFunction	ANSI-SQL style cast(foo as type) where the type is a Hibernate type
CharIndexFunction	Emulation of <tt>locate()</tt> on Sybase
ConditionalParenthesisFunction	Essentially the same as StandardSQLFunction, except that here the parentheses are not included when no arguments are given.
ConvertFunction	A Caché defintion of a convert function.
DB2SubstringFunction	When "substring" function is used for DB2, this implementation of StandardSQLFunction will render "substr" or "substring", depending on the last argument being used.
DerbyConcatFunction	A specialized concat() function definition in which:<ol> <li>we translate to use the concat operator ('||')</li> <li>wrap dynamic parameters in CASTs to VARCHAR</li> </ol> <p/> This last spec is to deal with a limitation on DB2 and variants (e.g.
NoArgSQLFunction	A function which takes no arguments
NvlFunction	Emulation of <tt>coalesce()</tt> on Oracle, using multiple <tt>nvl()</tt> calls
PositionSubstringFunction	Emulation of <tt>locate()</tt> on PostgreSQL
SQLFunctionRegistry	Defines a registry for SQLFunction instances
SQLFunctionTemplate	Represents HQL functions that can have different representations in different SQL dialects where that difference can be handled via a template/pattern.
StandardAnsiSqlAggregationFunctions	Centralized definition of standard ANSI SQL aggregation functions
StandardAnsiSqlAggregationFunctions.AvgFunction	Definition of a standard ANSI SQL compliant <tt>AVG</tt> function
StandardAnsiSqlAggregationFunctions.CountFunction	Definition of a standard ANSI SQL compliant <tt>COUNT</tt> function
StandardAnsiSqlAggregationFunctions.MaxFunction	Definition of a standard ANSI SQL compliant <tt>MAX</tt> function
StandardAnsiSqlAggregationFunctions.MinFunction	Definition of a standard ANSI SQL compliant <tt>MIN</tt> function
StandardAnsiSqlAggregationFunctions.SumFunction	Definition of a standard ANSI SQL compliant <tt>SUM</tt> function
StandardJDBCEscapeFunction	Analogous to StandardSQLFunction except that standard JDBC escape sequences (i.e.
StandardSQLFunction	Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.
StaticPrecisionFspTimestampFunction	A function that returns a StandardBasicTypes.TIMESTAMP with static fractional seconds precision (fsp).
TemplateRenderer	Delegate for handling function "templates".
TrimFunctionTemplate	Defines the basic template support for <tt>TRIM</tt> functions
TrimFunctionTemplate.Options
TrimFunctionTemplate.Specification
VarArgsSQLFunction	Support for slightly more general templating than StandardSQLFunction, with an unlimited number of arguments.

Package org.hibernate.dialect.function Description

<p> A framework for defining database-specific SQL functions that are available via the dialect. </p>