Class Functions
java.lang.Object
org.springframework.data.relational.core.sql.Functions
Factory for common
function expressions
.- Since:
- 1.1
- Author:
- Mark Paluch, Jens Schauder
- See Also:
-
Method Summary
Modifier and TypeMethodDescriptionstatic SimpleFunction
coalesce
(Expression... expressions) Creates a newCOALESCE
function.static SimpleFunction
count
(Collection<? extends Expression> columns) Creates a newCOUNT
function.static SimpleFunction
count
(Expression... columns) Creates a newCOUNT
function.static SimpleFunction
greatest
(List<? extends Expression> expressions) Creates a newGREATEST
function.static SimpleFunction
greatest
(Expression... expressions) Creates a newGREATEST
function.static SimpleFunction
least
(Expression... expressions) Creates a newLEAST
function.static SimpleFunction
lower
(Expression expression) Creates a newLOWER
function.static SimpleFunction
upper
(Expression expression) Creates a newUPPER
function.
-
Method Details
-
coalesce
Creates a newCOALESCE
function.- Parameters:
expressions
- expressions to applyCOALESCE
, must not be null.- Returns:
- the new
COALESCE function
forexpression
. - Since:
- 3.2
-
count
Creates a newCOUNT
function.- Parameters:
columns
- columns to applyCOUNT
, must not be null.- Returns:
- the new
COUNT function
forcolumns
.
-
count
Creates a newCOUNT
function.- Parameters:
columns
- columns to applyCOUNT
, must not be null.- Returns:
- the new
COUNT function
forcolumns
.
-
greatest
Creates a newGREATEST
function.- Parameters:
expressions
- expressions to applyGREATEST
, must not be null.- Returns:
- the new
GREATEST function
forexpression
. - Since:
- 3.2
-
greatest
Creates a newGREATEST
function.- Parameters:
expressions
- expressions to applyGREATEST
, must not be null.- Returns:
- the new
GREATEST function
forexpression
. - Since:
- 3.2
-
least
Creates a newLEAST
function.- Parameters:
expressions
- expressions to applyLEAST
, must not be null.- Returns:
- the new
LEAST function
forexpression
. - Since:
- 3.2
-
lower
Creates a newLOWER
function.- Parameters:
expression
- expression to applyLOWER
, must not be null.- Returns:
- the new
LOWER function
forexpression
. - Since:
- 2.0
-
upper
Creates a newUPPER
function.- Parameters:
expression
- expression to applyUPPER
, must not be null.- Returns:
- the new
UPPER function
forexpression
. - Since:
- 2.0
-