mondrian.spi.impl
Class PostgreSqlDialect

java.lang.Object
  extended by mondrian.spi.impl.JdbcDialectImpl
      extended by 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".

Get Mondrian at SourceForge.net. Fast, secure and free Open Source software downloads