Top Description Fields Constructors Methods

org.jooq.impl

pack-priv final Enum CombineOperator

Class Inheritance

extends Enum<CombineOperator>

java.lang.Object
java.lang.Enum
org.jooq.impl.CombineOperator

Static Imports

org.jooq.impl.Keywords.K_MINUS

A combine operator is used to combine result sets of two arbitrary Select queries.

Author: Lukas Eder

Field Summary

Modifier and Type	Field and Description
public static final CombineOperator	EXCEPT Remove all rows in the set of rows produced by the second `Select` from the set of rows produced by the first `Select` (disallowing duplicate records).
public static final CombineOperator	EXCEPT_ALL Remove all rows in the bag of rows produced by the second `Select` from the bag of rows produced by the first `Select` (allowing duplicate records).
public static final CombineOperator	INTERSECT Retain all rows in the sets of rows produced by both `Select`'s (disallowing duplicate records).
public static final CombineOperator	INTERSECT_ALL Retain all rows in the bags of rows produced by both `Select`'s (allowing duplicate records).
private final Keyword	keyword
private final Keyword	keywordOptionalDistinct
private final String	sql
public static final CombineOperator	UNION Unite the sets of rows produced by the two `Select`'s (disallowing duplicate records).
public static final CombineOperator	UNION_ALL Unite the bags of rows produced by the two `Select`'s (allowing duplicate records).

Constructor Summary

Access	Constructor and Description
private	CombineOperator(String sql, boolean distinct)

Method Summary

Modifier and Type	Method and Description
public final Keyword	toKeyword(SQLDialect dialect)
public final String	toSQL(SQLDialect dialect)
public static CombineOperator	valueOf(String name)
public static CombineOperator[]	values()

Inherited from java.lang.Enum:: clone compareTo describeConstable equals finalize getDeclaringClass hashCode name ordinal toString valueOf

Field Detail

EXCEPT	back to summary
public static final CombineOperator EXCEPT Remove all rows in the set of rows produced by the second `Select` from the set of rows produced by the first `Select` (disallowing duplicate records).

EXCEPT_ALL	back to summary
public static final CombineOperator EXCEPT_ALL Remove all rows in the bag of rows produced by the second `Select` from the bag of rows produced by the first `Select` (allowing duplicate records).

INTERSECT	back to summary
public static final CombineOperator INTERSECT Retain all rows in the sets of rows produced by both `Select`'s (disallowing duplicate records).

INTERSECT_ALL	back to summary
public static final CombineOperator INTERSECT_ALL Retain all rows in the bags of rows produced by both `Select`'s (allowing duplicate records).

keyword	back to summary
private final Keyword keyword

keywordOptionalDistinct	back to summary
private final Keyword keywordOptionalDistinct

sql	back to summary
private final String sql

UNION	back to summary
public static final CombineOperator UNION Unite the sets of rows produced by the two `Select`'s (disallowing duplicate records).

UNION_ALL	back to summary
public static final CombineOperator UNION_ALL Unite the bags of rows produced by the two `Select`'s (allowing duplicate records).

Constructor Detail

CombineOperator	back to summary
private CombineOperator(String sql, boolean distinct)

Method Detail

toKeyword	back to summary
public final Keyword toKeyword(SQLDialect dialect)

toSQL	back to summary
public final String toSQL(SQLDialect dialect)

valueOf	back to summary
public static CombineOperator valueOf(String name)

values	back to summary
public static CombineOperator[] values()