T
- result typepublic class PostgreSQLQuery<T> extends AbstractSQLQuery<T,PostgreSQLQuery<T>>
PostgreSQLQuery
provides PostgreSQL related extensions to SQLQuerySQLQuery
,
Serialized Formlisteners, PARENT_CONTEXT, useLiterals
configuration, firstUnionSubQuery, union, unionAll
MDC_PARAMETERS, MDC_QUERY, queryMixin
Constructor and Description |
---|
PostgreSQLQuery(Connection conn) |
PostgreSQLQuery(Connection conn,
Configuration configuration) |
PostgreSQLQuery(Connection conn,
Configuration configuration,
QueryMetadata metadata) |
PostgreSQLQuery(Connection conn,
SQLTemplates templates) |
PostgreSQLQuery(javax.inject.Provider<Connection> connProvider,
Configuration configuration) |
PostgreSQLQuery(javax.inject.Provider<Connection> connProvider,
Configuration configuration,
QueryMetadata metadata) |
Modifier and Type | Method and Description |
---|---|
PostgreSQLQuery<T> |
clone(Connection conn) |
PostgreSQLQuery<T> |
distinctOn(Expression<?>... exprs)
adds a DISTINCT ON clause
|
PostgreSQLQuery<T> |
forShare()
FOR SHARE causes the rows retrieved by the SELECT statement to be locked as though for update.
|
PostgreSQLQuery<T> |
noWait()
With NOWAIT, the statement reports an error, rather than waiting, if a selected row cannot
be locked immediately.
|
PostgreSQLQuery<T> |
of(RelationalPath<?>... paths)
FOR UPDATE / FOR SHARE OF tables
|
PostgreSQLQuery<Tuple> |
select(Expression<?>... exprs)
Change the projection of this query
|
<U> PostgreSQLQuery<U> |
select(Expression<U> expr)
Change the projection of this query
|
addListener, as, as, cleanupMDC, clone, clone, createSerializer, endContext, fetch, fetchCount, fetchResults, forShare, forUpdate, getConfiguration, getResults, getResults, iterate, logQuery, onException, setParameters, setStatementOptions, setUseLiterals, startContext
accept, addFlag, addFlag, addFlag, addFlag, addJoinFlag, addJoinFlag, fetchOne, from, from, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, getSQL, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, on, on, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, serialize, toString, union, union, union, unionAll, unionAll, unionAll, with, with, with, withRecursive, withRecursive, withRecursive
contains, contains, eq, eq, exists, getMetadata, getType, goe, goe, gt, gt, hashCode, in, in, isNotNull, isNull, loe, loe, lt, lt, ne, ne, notExists
equals, fetchFirst, transform, uniqueResult
distinct, groupBy, groupBy, having, having, limit, offset, orderBy, orderBy, restrict, set, where, where
finalize, getClass, notify, notifyAll, wait, wait, wait
distinct, limit, offset, orderBy, restrict, set
where
transform
fetchFirst
public PostgreSQLQuery(Connection conn)
public PostgreSQLQuery(Connection conn, SQLTemplates templates)
public PostgreSQLQuery(Connection conn, Configuration configuration)
public PostgreSQLQuery(Connection conn, Configuration configuration, QueryMetadata metadata)
public PostgreSQLQuery(javax.inject.Provider<Connection> connProvider, Configuration configuration, QueryMetadata metadata)
public PostgreSQLQuery(javax.inject.Provider<Connection> connProvider, Configuration configuration)
public PostgreSQLQuery<T> forShare()
forShare
in class AbstractSQLQuery<T,PostgreSQLQuery<T>>
public PostgreSQLQuery<T> noWait()
public PostgreSQLQuery<T> of(RelationalPath<?>... paths)
paths
- tablespublic PostgreSQLQuery<T> distinctOn(Expression<?>... exprs)
exprs
- public PostgreSQLQuery<T> clone(Connection conn)
clone
in class AbstractSQLQuery<T,PostgreSQLQuery<T>>
public <U> PostgreSQLQuery<U> select(Expression<U> expr)
FetchableQuery
expr
- new projectionpublic PostgreSQLQuery<Tuple> select(Expression<?>... exprs)
FetchableQuery
exprs
- new projectionCopyright © 2007–2016 Querydsl. All rights reserved.