mondrian.spi.impl
Class PostgreSqlDialect
java.lang.Object
mondrian.spi.impl.JdbcDialectImpl
mondrian.spi.impl.PostgreSqlDialect
- All Implemented Interfaces:
- Dialect
- Direct Known Subclasses:
- NetezzaDialect
public class PostgreSqlDialect
- extends JdbcDialectImpl
Implementation of Dialect
for the PostgreSQL database.
- Since:
- Nov 23, 2008
- Version:
- $Id: //open/mondrian/src/main/mondrian/spi/impl/PostgreSqlDialect.java#4 $
- Author:
- jhyde
Method Summary |
boolean |
requiresAliasForFromQuery()
Returns whether this Dialect requires subqueries in the FROM clause
to have an alias. |
boolean |
supportsOrderByNullsLast()
Returns whether this dialect supports "ASC NULLS LAST" and "DESC NULLS
LAST" applied to an item in the ORDER BY clause. |
Methods inherited from class mondrian.spi.impl.JdbcDialectImpl |
allowsAs, allowsCompoundCountDistinct, allowsCountDistinct, allowsDdl, allowsDialectSharing, allowsFromQuery, allowsMultipleCountDistinct, allowsMultipleDistinctSqlMeasures, allowsOrderByAlias, allowsSelectNotInGroupBy, appendHintsAfterFromClause, caseWhenElse, deduceIdentifierQuoteString, deduceMaxColumnNameLength, deduceProductName, deduceProductVersion, deduceReadOnly, deduceSupportedResultSetStyles, deduceSupportsSelectNotInGroupBy, generateInline, generateInlineForAnsi, generateInlineGeneric, generateOrderItem, getDatabaseProduct, getMaxColumnNameLength, getNullCollation, getProduct, getQuoteIdentifierString, needsExponent, quote, quoteBooleanLiteral, quoteDateLiteral, quoteDateLiteral, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteIdentifier, quoteNumericLiteral, quoteStringLiteral, quoteTimeLiteral, quoteTimestampLiteral, requiresGroupByAlias, requiresOrderByAlias, requiresUnionOrderByExprToBeInSelectClause, requiresUnionOrderByOrdinal, supportsGroupByExpressions, supportsGroupingSets, supportsMultiValueInExpr, supportsResultSetConcurrency, supportsUnlimitedValueList, toString, toUpper |
FACTORY
public static final JdbcDialectFactory FACTORY
PostgreSqlDialect
public PostgreSqlDialect(Connection connection)
throws SQLException
- Creates a PostgreSqlDialect.
- Parameters:
connection
- Connection
- Throws:
SQLException
requiresAliasForFromQuery
public boolean requiresAliasForFromQuery()
- Description copied from interface:
Dialect
- Returns whether this Dialect requires subqueries in the FROM clause
to have an alias.
- Specified by:
requiresAliasForFromQuery
in interface Dialect
- Overrides:
requiresAliasForFromQuery
in class JdbcDialectImpl
- Returns:
- whether dialewct requires subqueries to have an alias
- See Also:
Dialect.allowsFromQuery()
supportsOrderByNullsLast
public boolean supportsOrderByNullsLast()
- Description copied from class:
JdbcDialectImpl
- Returns whether this dialect supports "ASC NULLS LAST" and "DESC NULLS
LAST" applied to an item in the ORDER BY clause.
This feature is in standard SQL but is not supported by many
databases, therefore the default implementation returns false
.
This method is only called from
JdbcDialectImpl.generateOrderItem(String, boolean, boolean)
. Some dialects
override that method and therefore never call this method.
- Overrides:
supportsOrderByNullsLast
in class JdbcDialectImpl
- Returns:
- Whether this dialect supports "ORDER BY ... NULLS LAST".