Package com.arcadedb.query.sql.function.misc

Class SQLFunctionCoalesce

java.lang.Object

com.arcadedb.query.sql.function.SQLFunctionAbstract

com.arcadedb.query.sql.function.misc.SQLFunctionCoalesce

All Implemented Interfaces:

SQLFunction

public class SQLFunctionCoalesce
extends SQLFunctionAbstract

Returns the first field/value not null parameter. if no field/value is not null, returns null.

Syntax:

 coalesce(<field|value>[,<field|value>]*)
 

Examples:

 SELECT coalesce('a', 'b') FROM ...
  -> 'a'

 SELECT coalesce(null, 'b') FROM ...
  -> 'b'

 SELECT coalesce(null, null, 'c') FROM ...
  -> 'c'

 SELECT coalesce(null, null) FROM ...
  -> null

 

Author:

Claudio Tesoriero

Field Summary

Fields

Modifier and Type	Field	Description
static String	NAME

Fields inherited from class com.arcadedb.query.sql.function.SQLFunctionAbstract

name

Constructor Summary

Constructors

Constructor	Description
SQLFunctionCoalesce()

Method Summary

Modifier and Type	Method	Description
Object	execute(Object iThis, Identifiable iCurrentRecord, Object iCurrentResult, Object[] iParams, CommandContext iContext)	Process a record.
String	getSyntax()	Returns a convenient SQL String representation of the function.

Methods inherited from class com.arcadedb.query.sql.function.SQLFunctionAbstract

aggregateResults, config, getName, getResult, toString

Methods inherited from class java.lang.Object

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

Field Detail

NAME

public static final String NAME

See Also:

Constant Field Values

Constructor Detail

SQLFunctionCoalesce

public SQLFunctionCoalesce()

Method Detail

execute

public Object execute(Object iThis,
                      Identifiable iCurrentRecord,
                      Object iCurrentResult,
                      Object[] iParams,
                      CommandContext iContext)

Description copied from interface: SQLFunction

Process a record.

iCurrentRecord - : current record

iCurrentResult - TODO

iParams - : function parameters, number is ensured to be within minParams and maxParams.

iContext - : object calling this function

Returns:

function result, can be null. Special cases : can be null if function aggregate results, can be null if function filter results : this mean result is excluded

getSyntax

public String getSyntax()

Description copied from interface: SQLFunction

Returns a convenient SQL String representation of the function.

Example :

  myFunction( param1, param2, [optionalParam3])
 

This text will be used in exception messages.

Returns:

String , never null.