Package org.h2.mode
Class FunctionsPostgreSQL
java.lang.Object
org.h2.expression.Expression
org.h2.expression.OperationN
org.h2.expression.function.FunctionN
org.h2.mode.ModeFunction
org.h2.mode.FunctionsPostgreSQL
- All Implemented Interfaces:
ExpressionWithVariableParameters
,NamedExpression
,HasSQL
,Typed
Functions for
Mode.ModeEnum.PostgreSQL
compatibility
mode.-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate static final int
private static final int
private static final int
private static final int
private static final HashMap
<String, FunctionInfo> private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
private static final int
Fields inherited from class org.h2.mode.ModeFunction
info, VAR_ARGS
Fields inherited from class org.h2.expression.OperationN
args, argsCount, type
Fields inherited from class org.h2.expression.Expression
AUTO_PARENTHESES, MAP_IN_AGGREGATE, MAP_IN_WINDOW, MAP_INITIAL, WITH_PARENTHESES, WITHOUT_PARENTHESES
Fields inherited from interface org.h2.util.HasSQL
ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected void
checkParameterCount
(int len) Check if the parameter count is correct.private static String
encodingToChar
(int code) static FunctionsPostgreSQL
getFunction
(String upperName) Returns mode-specific function for a given name, ornull
.private static Value
getIndexdef
(SessionLocal session, int indexId, Value ordinalPosition, Value pretty) private static String
getUserbyid
(SessionLocal session, int uid) getValue
(SessionLocal session) Return the resulting value for the current row.optimize
(SessionLocal session) Try to optimize the expression.private static Value
relationSize
(SessionLocal session, Value tableOidOrName) Methods inherited from class org.h2.mode.ModeFunction
doneWithParameters, getArgumentsValues, getFunction, getName, getNullOrValue, isEverything, optimizeArguments
Methods inherited from class org.h2.expression.function.FunctionN
getUnenclosedSQL, getValue
Methods inherited from class org.h2.expression.OperationN
addParameter, getCost, getSubexpression, getSubexpressionCount, getType, mapColumns, optimizeArguments, setEvaluatable, updateAggregate
Methods inherited from class org.h2.expression.Expression
addFilterConditions, createIndexConditions, getAlias, getBooleanValue, getColumnName, getColumnNameForView, getEnclosedSQL, getNonAliasExpression, getNotIfPossible, getNullable, getSchemaName, getSQL, getSQL, getSQL, getSQL, getTableAlias, getTableName, getWhenSQL, getWhenValue, isConstant, isIdentity, isNullConstant, isValueSet, isWhenConditionOperand, needParentheses, optimizeCondition, toString, writeExpressions, writeExpressions
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.h2.util.HasSQL
getTraceSQL
-
Field Details
-
CURRENT_DATABASE
private static final int CURRENT_DATABASE- See Also:
-
CURRTID2
private static final int CURRTID2- See Also:
-
FORMAT_TYPE
private static final int FORMAT_TYPE- See Also:
-
HAS_DATABASE_PRIVILEGE
private static final int HAS_DATABASE_PRIVILEGE- See Also:
-
HAS_SCHEMA_PRIVILEGE
private static final int HAS_SCHEMA_PRIVILEGE- See Also:
-
HAS_TABLE_PRIVILEGE
private static final int HAS_TABLE_PRIVILEGE- See Also:
-
LASTVAL
private static final int LASTVAL- See Also:
-
VERSION
private static final int VERSION- See Also:
-
OBJ_DESCRIPTION
private static final int OBJ_DESCRIPTION- See Also:
-
PG_ENCODING_TO_CHAR
private static final int PG_ENCODING_TO_CHAR- See Also:
-
PG_GET_EXPR
private static final int PG_GET_EXPR- See Also:
-
PG_GET_INDEXDEF
private static final int PG_GET_INDEXDEF- See Also:
-
PG_GET_USERBYID
private static final int PG_GET_USERBYID- See Also:
-
PG_POSTMASTER_START_TIME
private static final int PG_POSTMASTER_START_TIME- See Also:
-
PG_RELATION_SIZE
private static final int PG_RELATION_SIZE- See Also:
-
PG_TABLE_IS_VISIBLE
private static final int PG_TABLE_IS_VISIBLE- See Also:
-
SET_CONFIG
private static final int SET_CONFIG- See Also:
-
ARRAY_TO_STRING
private static final int ARRAY_TO_STRING- See Also:
-
PG_STAT_GET_NUMSCANS
private static final int PG_STAT_GET_NUMSCANS- See Also:
-
TO_DATE
private static final int TO_DATE- See Also:
-
TO_TIMESTAMP
private static final int TO_TIMESTAMP- See Also:
-
FUNCTIONS
-
-
Constructor Details
-
FunctionsPostgreSQL
-
-
Method Details
-
getFunction
Returns mode-specific function for a given name, ornull
.- Parameters:
upperName
- the upper-case name of a function- Returns:
- the function with specified name or
null
-
checkParameterCount
protected void checkParameterCount(int len) Description copied from class:ModeFunction
Check if the parameter count is correct.- Overrides:
checkParameterCount
in classModeFunction
- Parameters:
len
- the number of parameters set
-
optimize
Description copied from class:Expression
Try to optimize the expression.- Specified by:
optimize
in classExpression
- Parameters:
session
- the session- Returns:
- the optimized expression
-
getValue
Description copied from class:Expression
Return the resulting value for the current row. -
encodingToChar
-
getIndexdef
private static Value getIndexdef(SessionLocal session, int indexId, Value ordinalPosition, Value pretty) -
getUserbyid
-
relationSize
-