Package org.apache.empire.dbms.postgresql

Class PostgresFuncExpr

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBColumnExpr

org.apache.empire.db.expr.column.DBAbstractFuncExpr

org.apache.empire.dbms.postgresql.PostgresFuncExpr

All Implemented Interfaces:

ColumnExpr, DBPreparable

public class PostgresFuncExpr
extends DBAbstractFuncExpr

Field Summary

Fields

Modifier and Type	Field	Description
protected final Object[]	params
protected final PostgresSqlPhrase	phrase

Fields inherited from class org.apache.empire.db.expr.column.DBAbstractFuncExpr

dataType, expr, isAggregate, log

Fields inherited from class org.apache.empire.db.DBColumnExpr

attributes, beanPropertyName, options

Fields inherited from class org.apache.empire.db.DBExpr

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE

Constructor Summary

Constructors

Constructor	Description
PostgresFuncExpr(DBColumnExpr expr, PostgresSqlPhrase phrase, Object[] params, DataType dataType)

Method Summary

Modifier and Type	Method	Description
void	addReferencedColumns(Set<DBColumn> list)	Internal function to obtain all DBColumnExpr-objects used by this expression.
void	addSQL(DBSQLBuilder sql, long context)	Creates the SQL-Command adds a function to the SQL-Command.
protected String	getFunctionName()	returns the name of the function

Methods inherited from class org.apache.empire.db.expr.column.DBAbstractFuncExpr

addSQL, addXml, equals, getDatabase, getDataType, getDbms, getEnumType, getName, getRowSet, getUpdateColumn, isAggregate, prepareParams

Methods inherited from class org.apache.empire.db.DBColumnExpr

abs, aggregate, append, as, as, asc, avg, ceiling, cmp, coalesce, concat, concat, contains, convertTo, convertTo, count, countDistinct, day, decode, decode, decode, decode, decode, decode, decodeEnum, decodeSort, desc, divideBy, floor, format, function, getAttribute, getAttribute, getBeanPropertyName, getControlType, getDefaultSortOrder, getExprFromPhrase, getExprFromPhrase, getIgnoreCaseExpr, getJavaType, getNumberType, getOptions, getSourceColumn, getTitle, in, in, in, indexOf, indexOf, indexOf, is, isBetween, isCaseSensitive, isGreaterThan, isLessOrEqual, isLiteralValue, isMoreOrEqual, isNot, isNotBetween, isSmallerThan, length, like, like, likeLower, likeUpper, lower, max, min, minus, minus, modulo, month, multiplyWith, notContains, notIn, notIn, notIn, notLike, nvl, on, parenthesis, plus, plus, prepend, qualified, replace, reverse, round, setAttribute, setBeanPropertyName, setControlType, setDefaultSortOrder, setOptions, setTitle, stringAgg, stringAgg, substring, substring, substring, substring, substring, substring, sum, toChar, toChar, toString, trim, trimLeft, trimRight, trunc, upper, when, year

Methods inherited from class org.apache.empire.db.DBObject

checkParamNull

Methods inherited from class java.lang.Object

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

Field Details

phrase

protected final PostgresSqlPhrase phrase

params

protected final Object[] params

Constructor Details

PostgresFuncExpr

public PostgresFuncExpr(DBColumnExpr expr,
 PostgresSqlPhrase phrase,
 Object[] params,
 DataType dataType)

Parameters:

expr - the DBColumnExpr object

phrase - the SQL-phrase

params - an array of params which will be replaced in the template

dataType - indicates the data type of the function result

Method Details

getFunctionName

protected String getFunctionName()

Description copied from class: DBAbstractFuncExpr

returns the name of the function

Specified by:

getFunctionName in class DBAbstractFuncExpr

Returns:

the function name

addReferencedColumns

public void addReferencedColumns(Set<DBColumn> list)

Description copied from class: DBExpr

Internal function to obtain all DBColumnExpr-objects used by this expression.

Overrides:

addReferencedColumns in class DBAbstractFuncExpr

Parameters:

list - list to which all used column expressions must be added

See Also:

• DBExpr.addReferencedColumns(Set)

addSQL

public void addSQL(DBSQLBuilder sql,
 long context)

Creates the SQL-Command adds a function to the SQL-Command.

Specified by:

addSQL in class DBExpr

Parameters:

sql - the SQL-Command

context - the current SQL-Command context