PostgreSQLQueryExpression (Castor JavaDoc)

java.lang.Object
- org.castor.cpa.persistence.sql.driver.JDBCQueryExpression
- - org.castor.cpa.persistence.sql.driver.PostgreSQLQueryExpression

All Implemented Interfaces:

QueryExpression
```
public final class PostgreSQLQueryExpression
extends JDBCQueryExpression
```
QueryExpression for PostgreSQL 6.5/7.

Version:

$Revision: 7585 $ $Date: 2004-10-01 13:45:49 -0600 (Fri, 01 Oct 2004) $

Author:

Assaf Arkin

Nested Class Summary
- Nested classes/interfaces inherited from class org.castor.cpa.persistence.sql.driver.JDBCQueryExpression
  JDBCQueryExpression.Join

Field Summary
- Fields inherited from class org.castor.cpa.persistence.sql.driver.JDBCQueryExpression
  _dbInfo, _distinct, _factory, _joins, _limit, _offset, _order, _select, _tables
- Fields inherited from interface org.exolab.castor.persist.spi.QueryExpression
  OP_BETWEEN, OP_BETWEEN_AND, OP_EQUALS, OP_GREATER, OP_GREATER_EQUALS, OP_LESS, OP_LESS_EQUALS, OP_LIKE, OP_NOT_EQUALS, OP_NOT_LIKE

Constructor Summary

Constructors
Constructor Description

PostgreSQLQueryExpression(PersistenceFactory factory)

Constructors
Constructor	Description
`PostgreSQLQueryExpression(PersistenceFactory factory)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`java.lang.String`	`getStatement(boolean lock)`	Creates a SQL statement.
`boolean`	`isLimitClauseSupported()`	Provides an implementation of `QueryExpression#isLimitClauseSupported()`.
`boolean`	`isOffsetClauseSupported()`	Provides an implementation of `QueryExpression#isOffsetClauseSupported()`.

Methods inherited from class org.castor.cpa.persistence.sql.driver.JDBCQueryExpression
addColumn, addCondition, addInnerJoin, addLimitClause, addOffsetClause, addOrderClause, addOuterJoin, addParameter, addSelect, addTable, addWhereClause, addWhereClause, clone, encodeColumn, getColumnList, getStandardStatement, setDbMetaInfo, setDistinct, toString

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - PostgreSQLQueryExpression
```
public PostgreSQLQueryExpression(PersistenceFactory factory)
```
- Method Detail
  - getStatement
```
public java.lang.String getStatement(boolean lock)
```
    Description copied from class: JDBCQueryExpression
    
    Creates a SQL statement. In general, for a RDBMS/JDBC driver with a full support of the SQL standard/JDBC specification, this will return a valid SQL statement. For some features, a particular RDBMS might indicate that it does not support this feature by throwing a SyntaxNotSupportedException.
    
    Specified by:
    
    getStatement in interface QueryExpression
    
    Overrides:
    
    getStatement in class JDBCQueryExpression
    
    Parameters:
    
    lock - True if a write lock is required
    
    Returns:
    
    The SQL statement
  - isLimitClauseSupported
```
public boolean isLimitClauseSupported()
```
    Provides an implementation of QueryExpression#isLimitClauseSupported().
    
    Specified by:
    
    isLimitClauseSupported in interface QueryExpression
    
    Overrides:
    
    isLimitClauseSupported in class JDBCQueryExpression
    
    Returns:
    
    true to indicate that this feature is supported by postgreSQL.
    
    See Also:
    
    QueryExpression.isLimitClauseSupported()
  - isOffsetClauseSupported
```
public boolean isOffsetClauseSupported()
```
    Provides an implementation of QueryExpression#isOffsetClauseSupported().
    
    Specified by:
    
    isOffsetClauseSupported in interface QueryExpression
    
    Overrides:
    
    isOffsetClauseSupported in class JDBCQueryExpression
    
    Returns:
    
    true to indicate that this feature is supported by postgreSQL.
    
    See Also:
    
    QueryExpression.isOffsetClauseSupported()

Class PostgreSQLQueryExpression

Nested Class Summary

Nested classes/interfaces inherited from class org.castor.cpa.persistence.sql.driver.JDBCQueryExpression

Field Summary

Fields inherited from class org.castor.cpa.persistence.sql.driver.JDBCQueryExpression

Fields inherited from interface org.exolab.castor.persist.spi.QueryExpression

Constructor Summary

Method Summary

Methods inherited from class org.castor.cpa.persistence.sql.driver.JDBCQueryExpression

Methods inherited from class java.lang.Object

Constructor Detail

PostgreSQLQueryExpression

Method Detail

getStatement

isLimitClauseSupported

isOffsetClauseSupported