Class CoalesceExpressionStateObject

All Implemented Interfaces:
ListHolderStateObject<StateObject>, StateObject

public class CoalesceExpressionStateObject extends AbstractEncapsulatedExpressionStateObject implements ListHolderStateObject<StateObject>
A COALESCE expression returns null if all its arguments evaluate to null, and the value of the first non-null argument otherwise.

The return type is the type returned by the arguments if they are all of the same type, otherwise it is undetermined.

BNF: coalesce_expression::= COALESCE(scalar_expression {, scalar_expression}+)
Since:
2.4
Version:
2.4
See Also: