Comparator (jOOQ 3.9.6 API)

java.lang.Object
- java.lang.Enum<Comparator>
- - org.jooq.Comparator

All Implemented Interfaces:

Serializable, Comparable<Comparator>
```
public enum Comparator
extends Enum<Comparator>
```
A comparator to be used in conditions to form comparison predicates.
Comparison operators listed here can be used to compare Field or Row values with other Field or Row values, or with Select or QuantifiedSelect values.
The following flags indicate whether the comparator can be used as:
- a quantified comparison operator: supportsQuantifier(). Example: X = ANY (A, B, C)
- a subselect comparison operator: supportsSubselect(). Example: X = (SELECT A)
Author:

Lukas Eder

Enum Constant Summary

Enum Constants
Enum Constant and Description
`EQUALS`
`GREATER`
`GREATER_OR_EQUAL`
`IN`
`IS_DISTINCT_FROM`
`IS_NOT_DISTINCT_FROM`
`LESS`
`LESS_OR_EQUAL`
`LIKE`
`LIKE_IGNORE_CASE`
`NOT_EQUALS`
`NOT_IN`
`NOT_LIKE`
`NOT_LIKE_IGNORE_CASE`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`supportsQuantifier()` Whether this comparator supports quantifiers on the right-hand side.
`boolean`	`supportsSubselect()` Whether this comparator supports subselects on the right-hand side.
`String`	`toSQL()` A SQL rendition of this comparator.
`static Comparator`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static Comparator[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

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

- Enum Constant Detail
  - IN
```
@Support
public static final Comparator IN
```
  - NOT_IN
```
@Support
public static final Comparator NOT_IN
```
  - EQUALS
```
@Support
public static final Comparator EQUALS
```
  - NOT_EQUALS
```
@Support
public static final Comparator NOT_EQUALS
```
  - LESS
```
@Support
public static final Comparator LESS
```
  - LESS_OR_EQUAL
```
@Support
public static final Comparator LESS_OR_EQUAL
```
  - GREATER
```
@Support
public static final Comparator GREATER
```
  - GREATER_OR_EQUAL
```
@Support
public static final Comparator GREATER_OR_EQUAL
```
  - IS_DISTINCT_FROM
```
@Support
public static final Comparator IS_DISTINCT_FROM
```
  - IS_NOT_DISTINCT_FROM
```
@Support
public static final Comparator IS_NOT_DISTINCT_FROM
```
  - LIKE
```
@Support
public static final Comparator LIKE
```
  - NOT_LIKE
```
@Support
public static final Comparator NOT_LIKE
```
  - LIKE_IGNORE_CASE
```
@Support
public static final Comparator LIKE_IGNORE_CASE
```
  - NOT_LIKE_IGNORE_CASE
```
@Support
public static final Comparator NOT_LIKE_IGNORE_CASE
```
- Method Detail
  - values
```
public static Comparator[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (Comparator c : Comparator.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static Comparator valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
    
    Parameters:
    
    name - the name of the enum constant to be returned.
    
    Returns:
    
    the enum constant with the specified name
    
    Throws:
    
    IllegalArgumentException - if this enum type has no constant with the specified name
    
    NullPointerException - if the argument is null
  - toSQL
```
public String toSQL()
```
    A SQL rendition of this comparator.
  - supportsQuantifier
```
public boolean supportsQuantifier()
```
    Whether this comparator supports quantifiers on the right-hand side.
  - supportsSubselect
```
public boolean supportsSubselect()
```
    Whether this comparator supports subselects on the right-hand side.

Enum Comparator

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

IN

NOT_IN

EQUALS

NOT_EQUALS

LESS

LESS_OR_EQUAL

GREATER

GREATER_OR_EQUAL

IS_DISTINCT_FROM

IS_NOT_DISTINCT_FROM

LIKE

NOT_LIKE

LIKE_IGNORE_CASE

NOT_LIKE_IGNORE_CASE

Method Detail

values

valueOf

toSQL

supportsQuantifier

supportsSubselect