public class PostgresqlSqlDialect extends SqlDialect
SqlDialect
implementation for the PostgreSQL database.SqlDialect.CalendarPolicy, SqlDialect.Context, SqlDialect.DatabaseProduct, SqlDialect.FakeUtil
Modifier and Type | Field and Description |
---|---|
static SqlDialect |
DEFAULT |
private static RelDataTypeSystem |
POSTGRESQL_TYPE_SYSTEM
PostgreSQL type system.
|
BUILT_IN_OPERATORS_LIST, CALCITE, DUMMY, EMPTY_CONTEXT, LOGGER, nullCollation
Constructor and Description |
---|
PostgresqlSqlDialect(SqlDialect.Context context)
Creates a PostgresqlSqlDialect.
|
Modifier and Type | Method and Description |
---|---|
SqlNode |
getCastSpec(RelDataType type) |
protected boolean |
requiresAliasForFromItems() |
boolean |
supportsCharSet()
Returns whether the dialect supports character set names as part of a
data type, for instance
VARCHAR(30) CHARACTER SET `ISO-8859-1` . |
boolean |
supportsNestedAggregations()
Returns whether the dialect supports nested aggregations, for instance
SELECT SUM(SUM(1)) . |
void |
unparseCall(SqlWriter writer,
SqlCall call,
int leftPrec,
int rightPrec) |
allowsAs, configureParser, create, defaultNullDirection, emptyContext, emulateJoinTypeForCrossJoin, emulateNullDirection, emulateNullDirectionWithIsNull, getCalendarPolicy, getConformance, getDatabaseProduct, getNullCollation, getProduct, getQuotedCasing, getQuoting, getTypeSystem, getUnquotedCasing, hasImplicitTableAlias, isCaseSensitive, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteStringLiteral, quoteStringLiteralUnicode, quoteTimestampLiteral, rewriteSingleValueExpr, supportsAggregateFunction, supportsAliasedValues, supportsFunction, supportsGroupByWithCube, supportsGroupByWithRollup, supportsOffsetFetch, supportsWindowFunctions, unparseDateTimeLiteral, unparseFetchUsingAnsi, unparseFetchUsingLimit, unparseOffsetFetch, unparseSqlDatetimeArithmetic, unparseSqlIntervalLiteral, unparseSqlIntervalQualifier, unquoteStringLiteral
private static final RelDataTypeSystem POSTGRESQL_TYPE_SYSTEM
public static final SqlDialect DEFAULT
public PostgresqlSqlDialect(SqlDialect.Context context)
public boolean supportsCharSet()
SqlDialect
VARCHAR(30) CHARACTER SET `ISO-8859-1`
.supportsCharSet
in class SqlDialect
public SqlNode getCastSpec(RelDataType type)
getCastSpec
in class SqlDialect
protected boolean requiresAliasForFromItems()
requiresAliasForFromItems
in class SqlDialect
public boolean supportsNestedAggregations()
SqlDialect
SELECT SUM(SUM(1))
.supportsNestedAggregations
in class SqlDialect
public void unparseCall(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec)
unparseCall
in class SqlDialect
Copyright © 2012–2019 The Apache Software Foundation. All rights reserved.