public class PostgresIntervalExpr extends DBColumnExpr
| Modifier and Type | Class and Description |
|---|---|
static class |
PostgresIntervalExpr.PostgresIntervalUnitField |
attributes, beanPropertyName, DBCOLATTR_TITLE, DBCOLATTR_TYPE, optionsCTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE| Constructor and Description |
|---|
PostgresIntervalExpr(DBDatabase db,
int quantity,
PostgresIntervalExpr.PostgresIntervalUnitField unit) |
| Modifier and Type | Method and Description |
|---|---|
PostgresIntervalExpr |
add(int quantity,
PostgresIntervalExpr.PostgresIntervalUnitField unit) |
void |
addReferencedColumns(Set<DBColumn> list)
Internal function to obtain all DBColumnExpr-objects used by this expression.
|
void |
addSQL(DBSQLBuilder sql,
long context)
Used to build the SQL command.
|
Element |
addXml(Element parent,
long flags)
Add a description of this column with relevant metadata
to the supplied parent XML Element.
|
DBDatabase |
getDatabase()
Returns the database object to which this object belongs to.
|
DataType |
getDataType()
Returns the data type of this column expression.
|
Class<Enum<?>> |
getEnumType()
Returns the enum type for this column
|
String |
getName()
Returns the column name for this column expression.
|
DBRowSet |
getRowSet()
Returns the underlying rowset containing this column
For functions involving none or more than one physical column this function return the first one
|
DBColumn |
getUpdateColumn()
Returns the underlying physical column.
|
boolean |
isAggregate()
Indicates whether this function is an aggregate (sum, min, max, avg, ...) or not
|
abs, aggregate, append, as, as, asc, avg, ceiling, cmp, coalesce, concat, concat, convertTo, convertTo, count, countDistinct, day, decode, decode, decode, decode, decode, decode, decodeEnum, decodeSort, desc, divideBy, floor, format, function, getAttribute, getBeanPropertyName, getControlType, getExprFromPhrase, getExprFromPhrase, getJavaType, getOptions, getSourceColumn, getTitle, in, in, in, indexOf, indexOf, indexOf, is, isBetween, isGreaterThan, isLessOrEqual, isMoreOrEqual, isNot, isNotBetween, isSmallerThan, length, like, like, likeLower, likeUpper, lower, max, min, minus, minus, modulo, month, multiplyWith, notIn, notIn, notIn, notLike, nvl, on, parenthesis, plus, plus, prepend, qualified, replace, reverse, round, setAttribute, setBeanPropertyName, setControlType, setOptions, setTitle, stringAgg, stringAgg, substring, substring, substring, substring, substring, substring, sum, toChar, toChar, toString, trim, trimLeft, trimRight, trunc, upper, when, yearcheckParamNullpublic PostgresIntervalExpr(DBDatabase db, int quantity, PostgresIntervalExpr.PostgresIntervalUnitField unit)
public final DBDatabase getDatabase()
DBObjectgetDatabase in class DBObjectpublic DataType getDataType()
DBColumnExprgetDataType in interface ColumnExprgetDataType in class DBColumnExprDataTypepublic Class<Enum<?>> getEnumType()
ColumnExprpublic String getName()
DBColumnExprgetName in interface ColumnExprgetName in class DBColumnExprpublic DBRowSet getRowSet()
DBColumnExprgetRowSet in class DBColumnExprpublic DBColumn getUpdateColumn()
DBColumnExprgetUpdateColumn in interface ColumnExprgetUpdateColumn in class DBColumnExprpublic boolean isAggregate()
DBColumnExprisAggregate in class DBColumnExprpublic Element addXml(Element parent, long flags)
DBColumnExpraddXml in class DBColumnExprparent - the parent element to which to append the column descriptionflags - currently not usedpublic void addSQL(DBSQLBuilder sql, long context)
DBExprpublic PostgresIntervalExpr add(int quantity, PostgresIntervalExpr.PostgresIntervalUnitField unit)
public void addReferencedColumns(Set<DBColumn> list)
DBExpraddReferencedColumns in class DBExprlist - list to which all used column expressions must be addedCopyright © 2008–2023 Apache Software Foundation. All rights reserved.