Interface | Description |
---|---|
FromItem |
An item in a "SELECT [...] FROM item1" statement.
|
FromItemVisitor | |
IntoTableVisitor | |
OrderByVisitor | |
PivotVisitor | |
SelectBody | |
SelectItem |
Anything between "SELECT" and "FROM"
(that is, any column or expression etc to be retrieved with the query) |
SelectItemVisitor | |
SelectVisitor |
Class | Description |
---|---|
AllColumns |
All the columns (as in "SELECT * FROM ...")
|
AllTableColumns | |
Distinct |
A DISTINCT [ON (expression, ...)] clause
|
ExceptOp | |
ExpressionListItem | |
Fetch |
A fetch clause in the form FETCH (FIRST | NEXT) row_count (ROW | ROWS) ONLY
|
FromItemVisitorAdapter | |
FunctionItem | |
IntersectOp | |
IntoTableVisitorAdapter | |
Join |
A join clause
|
LateralSubSelect |
A lateral subselect followed by an alias.
|
Limit |
A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL)
OFFSET offset}]
|
MinusOp | |
Offset |
An offset clause in the form OFFSET offset
or in the form OFFSET offset (ROW | ROWS)
|
OrderByElement |
An element (column reference) in an "ORDER BY" clause.
|
OrderByVisitorAdapter | |
Pivot | |
PivotVisitorAdapter | |
PivotXml | |
PlainSelect |
The core of a "SELECT" statement (no UNION, no ORDER BY)
|
Select | |
SelectExpressionItem |
An expression as in "SELECT expr1 AS EXPR"
|
SelectItemVisitorAdapter | |
SelectVisitorAdapter | |
SetOperation |
Single Set-Operation (name).
|
SetOperationList |
A database set operation.
|
SubJoin |
A table created by "(tab1 join tab2)".
|
SubSelect |
A subselect followed by an optional alias.
|
Top |
A top clause in the form [TOP (row_count) or TOP row_count]
|
UnionOp | |
ValuesList |
This is a container for a values item within a select statement.
|
WithItem |
One of the parts of a "WITH" clause of a "SELECT" statement
|
Enum | Description |
---|---|
OrderByElement.NullOrdering | |
SetOperationList.SetOperationType |
list of set operations.
|
Copyright © 2006–2018 TinyGroup. All rights reserved.