DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery
Modifier and Type | Field and Description |
---|---|
protected int |
limit |
protected int |
skip |
autoPrepareStmt, cmdParams, groupBy, having, joins, log, parentTables, select, selectDistinct, set, where
cmdQuery, orderBy
CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE
Constructor and Description |
---|
DBCommandPostgres(DBMSHandlerPostgreSQL dbms,
boolean autoPrepareStmt) |
Modifier and Type | Method and Description |
---|---|
protected void |
addUpdateWithJoins(DBSQLBuilder sql,
DBRowSet table) |
void |
clearLimit()
Clears a limit or offset set by calling limit() or offset()
|
void |
getSelect(DBSQLBuilder sql)
Creates a select SQL-Statement
|
DBCommand |
limitRows(int numRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
DBColumnExpr |
pgAge(DBColumnExpr expr)
See https://www.postgresql.org/docs/current/functions-datetime.html
|
DBColumnExpr |
pgAge(DBColumnExpr expr1,
DBColumnExpr expr2)
See https://www.postgresql.org/docs/current/functions-datetime.html
|
DBColumnExpr |
pgBoolAnd(DBCompareExpr cmpExpr)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
DBColumnExpr |
pgBoolOr(DBCompareExpr cmpExpr)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
PostgresAtAt |
pgCompareAtAt(DBColumnExpr left,
DBColumnExpr right)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
DBColumnExpr |
pgExtract(PostgresExtractField field,
DBColumnExpr expr)
See https://www.postgresql.org/docs/current/functions-datetime.html
|
PostgresIntervalExpr |
pgInterval(int quantity,
PostgresIntervalExpr.PostgresIntervalUnitField unit) |
DBColumnExpr |
pgPlaintoTsquery(DBColumnExpr expr)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
DBColumnExpr |
pgToTsquery(DBColumnExpr expr)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
DBColumnExpr |
pgToTsvector(DBColumnExpr expr)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
DBColumnExpr |
pgWebsearchToTsquery(DBColumnExpr expr)
See https://www.postgresql.org/docs/current/textsearch-controls.html
|
DBCommand |
skipRows(int numRows)
Overridden to change return type from DBCommandExpr to DBCommand
|
addDeleteForTable, addDeleteWithJoins, addFrom, addGrouping, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addUpdateForTable, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clear, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, createSQLBuilder, findConstraintOn, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getParams, getParamValues, getRowSetList, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, join, joinLeft, joinLeft, joinRight, joinRight, orderBy, orderBy, orderBy, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, set, set, setConstraint, setParentTables, useCmdParam, where, where
addListExpr, addSQL, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, hasOrderBy, intersect, result, union, unionAll
checkParamNull
public DBCommandPostgres(DBMSHandlerPostgreSQL dbms, boolean autoPrepareStmt)
public DBColumnExpr pgAge(DBColumnExpr expr)
public DBColumnExpr pgAge(DBColumnExpr expr1, DBColumnExpr expr2)
public DBColumnExpr pgExtract(PostgresExtractField field, DBColumnExpr expr)
public DBColumnExpr pgToTsquery(DBColumnExpr expr)
public DBColumnExpr pgToTsvector(DBColumnExpr expr)
public DBColumnExpr pgPlaintoTsquery(DBColumnExpr expr)
public DBColumnExpr pgWebsearchToTsquery(DBColumnExpr expr)
public DBColumnExpr pgBoolAnd(DBCompareExpr cmpExpr)
public DBColumnExpr pgBoolOr(DBCompareExpr cmpExpr)
public PostgresAtAt pgCompareAtAt(DBColumnExpr left, DBColumnExpr right)
public PostgresIntervalExpr pgInterval(int quantity, PostgresIntervalExpr.PostgresIntervalUnitField unit)
public DBCommand limitRows(int numRows)
DBCommand
public DBCommand skipRows(int numRows)
DBCommand
public void clearLimit()
DBCommandExpr
clearLimit
in class DBCommandExpr
public void getSelect(DBSQLBuilder sql)
DBCommand
protected void addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table)
addUpdateWithJoins
in class DBCommand
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.