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

Nested Class Summary

Nested classes/interfaces inherited from interface mondrian.spi.Dialect

Dialect.DatabaseProduct, Dialect.Datatype, Dialect.NullCollation

Field Summary

static JdbcDialectFactory

FACTORY

Fields inherited from class mondrian.spi.impl.JdbcDialectImpl

databaseProduct, permitsSelectNotInGroupBy, productVersion

Constructor Summary

PostgreSqlDialect(java.sql.Connection connection)
Creates a PostgreSqlDialect.

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

FACTORY

public static final JdbcDialectFactory FACTORY

Constructor Detail

PostgreSqlDialect

public PostgreSqlDialect(java.sql.Connection connection)
                  throws java.sql.SQLException

Creates a PostgreSqlDialect.

Parameters:

connection - Connection

Throws:

java.sql.SQLException

Method Detail

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".