Package com.gigaspaces.query.sql.functions.extended

Class CoalesceSqlFunction

java.lang.Object

com.gigaspaces.query.sql.functions.SqlFunction

com.gigaspaces.query.sql.functions.extended.CoalesceSqlFunction

public class CoalesceSqlFunction
extends SqlFunction

The COALESCE function returns the first of its arguments that is not null. Null is returned only if all arguments are null. It is often used to substitute a default value for null values when data is retrieved for display

Constructor Summary

Constructors

Constructor	Description
CoalesceSqlFunction()

Method Summary

Modifier and Type	Method	Description
Object	apply(SqlFunctionExecutionContext context)	Defines the action to be performed on the stored object.

Methods inherited from class com.gigaspaces.query.sql.functions.SqlFunction

assertNumberOfArguments, assertNumberOfArguments, fromSqlTypeName, isString, isWholeNumber

Methods inherited from class java.lang.Object

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

Constructor Details

CoalesceSqlFunction

public CoalesceSqlFunction()

Method Details

apply

public Object apply(SqlFunctionExecutionContext context)

Description copied from class: SqlFunction

Defines the action to be performed on the stored object.

Specified by:

apply in class SqlFunction

Parameters:

context - contains the arguments, SqlFunctionExecutionContext

Returns:

The Stored object after applying the action