ANSI-SQL substring Documented in: ANSI X3.135-1992 American National Standard for Information Systems - Database Language - SQL

A SQLFunction implementation that emulates the ANSI SQL trim function on dialects which do not support the full definition. However, this function definition does assume the availability of ltrim, rtrim, and replace functions which it uses in various combinations to emulate the desired ANSI trim() functionality.

ANSI-SQL style cast(foo as type) where the type is a NHibernate type

Emulation of locate() on Sybase

Classic AVG sqlfunction that return types as it was done in Hibernate 3.1

Classic COUNT sqlfunction that return types as it was done in Hibernate 3.1

Classic SUM sqlfunction that return types as it was done in Hibernate 3.1

Summary description for NoArgSQLFunction.

Emulation of coalesce() on Oracle, using multiple nvl() calls

Emulation of locate() on PostgreSQL

Represents HQL functions that can have different representations in different SQL dialects. E.g. in HQL we can define function

CopyC#

concat(?1, ?2)

to concatenate two strings p1 and p2. Target SQL function will be dialect-specific, e.g.

CopyC#

(?1 || ?2)

for Oracle,

CopyC#

concat(?1, ?2)

for MySql,

CopyC#

(?1 + ?2)

for MS SQL. Each dialect will define a template as a string (exactly like above) marking function parameters with '?' followed by parameter's index (first index is 1).

Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.

Provides a standard implementation that supports the majority of the HQL functions that are translated to SQL.

Support for slightly more general templating than StandardSQLFunction, with an unlimited number of arguments.

Provides support routines for the HQL functions as used in the various SQL Dialects Provides an interface for supporting various HQL functions that are translated to SQL. The Dialect and its sub-classes use this interface to provide details required for processing of the function.